Useful for relatively large databases?

first post: shipguy wrote: I'm curious to know if the SQL Database Migration Wizard has been u...

latest post: ghuey wrote: Yes, I have done that, but it took me something like 3 days. I hav...

Azure Database Copy

first post: ppumkin wrote: All these features are awesome. But I seem to find my self copying...

latest post: ghuey wrote: Hi, I am not sure that I understand, but is your request to drop a...

Remember logins

first post: ppumkin wrote: Hi, This application is awesome! Just one thing that is startin...

latest post: ghuey wrote: Hi, Totally agree. I hate typing in the server / db / users creds...

v4.0.15 source

first post: paulhuck wrote: Is the source code for the v4 edition available? The Source Code a...

latest post: ghuey wrote: Hi, The only difference between v4 and v3 is that I change the ref...

dependencies for SQLAzureMW are missing . Version 3.9.12

first post: Kwilksys wrote: hi, I have downloaded the latest version on windows 8 . Have unzi...

latest post: Kwilksys wrote: hi I have use the wrong version for sql 2012 and it is now workin...

migration error. SQL to Azure

first post: mkariti wrote: Hi there, Im keep getting the following errors: 03/04/2013 22:10:1...

latest post: mkariti wrote: Hi George, Tried to contact you via PM but not sure if you got it. ...

Copying azure database more then once.

first post: WiseMonkey wrote: I am trying to use SQL Database Migration Wizard 4.0.14 to get data...

latest post: ghuey wrote: Hi, You what was the error? In regards to do you have to start ov...

While generating SQL script with SQLAzureMW tool, if failed with an error.

first post: g17610 wrote: Hi, I tried to use the SQLAzureMW tool to migrate a database to S...

latest post: ghuey wrote: Hi, Right off, it does not look like BCP.exe can be found. If you...

Error #: 207 -- Invalid column name

first post: sharonmvp wrote: Dear Friends , in the processing stage i can see the following Er...

latest post: sharonmvp wrote: Dear George, Thanks you for the prompt responded. what is the emai...

Uploading database to local SQL Server creates big transaction log files

first post: tiny wrote: Hi, I'm using SQL Database Migration Wizard to migrate big (> 100...

latest post: ghuey wrote: Hi Marian, Very good point and no, I don’t have anything in the pr...

An issue when migrate large data

first post: shenjian wrote: Hi, When I use SqlAzureMW to migrate a large data to SQL Azure, I...

latest post: shenjian wrote: Really thanks ghuey. You fixed my problem.

missing millions of rows.

first post: lowercase_g wrote: I have a table with over 5 million rows. When I run through the scr...

latest post: ghuey wrote: Well, good question and I don't have a good answer. I take it that...

Data migration issue

first post: Shamassaeedmr wrote: What happen when I use SQLAzureMW to migrate data from my local db ...

latest post: ghuey wrote: Hi, SQLAzureMW generates scripts that basically checks if table do...

Table Creation Error (DATA_COMPRESSION)

first post: Davd_Molina wrote: Found a condition were an index on the local db had "DATA_COMP...

latest post: ghuey wrote: Thanks. For now, if you want, edit NotSupportedByAzureFile.Config ...

Error Using SQL Database Migration Wizard for (LocalDB)/v11.0

first post: TerryMc wrote: I am using the SQL Database Migration Wizard, version 4.0.12, for ...

latest post: TerryMc wrote: It works now! That was the problem, an older version of BCP. I u...

Existing Azure DB

first post: mxmissile wrote: I have an existing Azure DB that I have loaded tables in for anoth...

latest post: ghuey wrote: You are 100% correct! It will not effect any tables that already ...

Can you change the server default Collation or is it possible change the collation that is selected by default

first post: michaelallison wrote: Hi I'm trying to upload a DB to SQL Azure. I have successfully mig...

latest post: ghuey wrote: Hi Michael, Download v3.9.9.1 or v4.0.12.1 and edit the SQLAzureMW...

SQL error when migrating SQL DB to Azure SQL

first post: gresziu wrote: Hi all, using the SQL Azure Migration Wizard tool, I get the follo...

latest post: gresziu wrote: Thanks for that!!

SQL Database Migration Wizard is not supported in Chinese-based OS

first post: regionbbs wrote: Hi all, I use SQL Database Migration Wizard (latest version) in my...

latest post: regionbbs wrote: Hi, I have found a solution: modify language to support Traditiona...

Target Server Connection to (localDb)\v11.0 fails with "does not support encryption"

first post: stocksp wrote: Very smooth From (localDb)\v11.0 to Azure .... thank you! But when...

latest post: stocksp wrote: Works like a charm ... soooo much nicer than Management Studio. tha...

Can't access data from localDb

first post: markheath wrote: I've been trying to use this tool to upload all the data froma loc...

latest post: markheath wrote: hi George, Using the named pipe as server name doesn't work in eith...

SQLAzureMWBatchBackup tool and database object selection

first post: vipreese wrote: We are inspecting a possibility of using automated scripts utilizi...

latest post: vipreese wrote: Many, many thanks George. The object selector works great!

QUOTE_IDENTIFIER error when migrating a database

first post: lemayp wrote: Hello, I am trying to migrate a large database between SQL Server ...

latest post: ghuey wrote: Hi, If you don't mind, would you contact me via Codeplex and we c...

Not able to launch in Windows 8

first post: shailensukul wrote: I am not able to launch this on my Windows 8 PC, even when run in ...

latest post: ghuey wrote: Hi, I am happy you got SQLAzureMW running. Thanks for working with...

Put all foreign key constraints at end of TSQL script

first post: WayneBrantley wrote: I see the source shows where this was done, but it is not complete...

latest post: ghuey wrote: Ok, I think I catch all of the constraints. Check out the latest v...

No data transferred, log appears to have done it, but its not there.

first post: lukepuplett wrote: Hi, I'm guessing my data is supposed to me copied over to Azure. I...

latest post: lukepuplett wrote: Hi George -- thanks for the prompt action. Having achieved a migrat...

Thanks

first post: kingfenix wrote: OMG!! this is the greatest project yet on codeplex for me. Thank...

latest post: ghuey wrote:  Hi Doug, You are correct in that you can't do cross database qu...

Large databases

first post: ben555 wrote: Can I make a couple of suggestions for dealing with large database...

latest post: ghuey wrote: Hi, thanks for the suggestions. Item a) has been on my mind a lon...

How to migrate a database that lives locally in the App_Data folder

first post: jalbao wrote: I have an ASP.NET MVC 4 application that includes a SQL Express da...

latest post: ghuey wrote: Hi, Sorry to say, but no, SQLAzureMW does not work directly again...

No data of DB is transferred to SQL Azure

first post: ekb wrote: Hello! I'm trying to transfer data from your program from the MS S...

latest post: ekb wrote: BCP version 10.50.2500.0. I will send TSQL later

select source screen showing all databases but grayed out

first post: robertob wrote: i was trying to migrate an existing sql azure database deployment t...

latest post: karstenj wrote: I hit this too and worked around it by downloading the source code ...

Failed to connect server

first post: madloo wrote: I wanna create a SqlAzure Database Account for this tool, and I se...

latest post: madloo wrote: I solved it by add same user in master database.

I ran the Wizard but there wasn't any data included...

first post: robvig wrote: I ran the Wizard but there wasn't any data included... I didn't se...

latest post: ghuey wrote: Hi Rob, In the downloads section of this site you will see "SQLAzur...

Error: Index was outside the bounds of the array.

first post: dgetty wrote: Hello, I receive the error when attempting to migrate a local data...

latest post: ghuey wrote:  Hi All, Ok, I made some changes that might help a little. I us...

SQL Azure to SQL 2012 scripting failure

first post: jillian wrote: Have downloaded v4.0.2. Initially replaced my older version BatchB...

latest post: ghuey wrote: I believe that I have the issue fixed. Can you try v4.0.3 and see ...

Ran SQLAzureMW but Azure database not updated

first post: RobertNeal wrote: I downloaded Version 3.8.4 today. I followed the wizard to upload ...

latest post: colinwiseman wrote: Fixed it :D And sorry to have bothered. The problem here wasn't wit...

Index was outside the bounds of the array (but a little bit different)

first post: ventrue wrote: Hi all! I'm running this tool in a computer with no sql server in...

latest post: ghuey wrote: I am not 100% sure. What I would do is download SQL Server 2008 R2...

SQLAzureMW data migration stories

first post: ghuey wrote:  Hi All, I am looking for feedback from companies who ...

latest post: ghuey wrote: Thanks very much for the reply and the positive feedback!!!

Frequent connection error

first post: axdev wrote: WE are trying to migrate our database to SQL Azure and I am hitting...

latest post: lwsouza wrote: Hello ! I use SQLAzure on demand, web platform; I have only on...

Running tools on Web, Worker Roles

first post: auspicious wrote: I'd prefer to use these tools instead of the DAC Import/Export ser...

latest post: FlorinDumitrescu wrote: Hi George, The test was done on a local clean virtual machine. As f...

NumberOfBCPThreads setting not available in 2 command utilities?

first post: auspicious wrote: Any reason why this was dropped from the backup/restore utilities?...

latest post: ghuey wrote: Hi Auspicious, I added parallel uploading to SQLAzureMWBatchUplo...

Error: Index was outside the bounds of the array

first post: delfo wrote: Hi,i have installed and run the wizard and all works fine until i r...

latest post: kokujin wrote: Hello This does not work for me. I've had my DB Admins update our t...

SQLAzureMWBatchUpload Parameter DropOldDatabaseIfExists

first post: chriseull wrote: Is there a way with the command line parameter to override the conf...

latest post: chriseull wrote: Hello George, The missing SpecialTableCharacters key was the issue...

Migration wizard error

first post: ProjectMala wrote: The migration wizard gets almost to the end and then puts up an err...

latest post: ghuey wrote: Hi,I just wanted to check back with you and see if you got things r...

SQLAzureMW have a bug serious

first post: rong505968 wrote: when I start SQLAzureMW.exe,and input imformation of service for Sq...

latest post: prozac777 wrote: I was getting the same error when trying to update an existing dat...

Inserting Data

first post: fatih wrote: Hi,First of all,thanks for this great tool;but i have a question ab...

latest post: ghuey wrote: Hi Max!This is great to know and I will make the change.Thank you v...

Problem with Backup command line tool

first post: ebenjamin wrote: I have noticed that starting abound the 19th of September the comma...

latest post: ebenjamin wrote: Hi George,The change has been working great. Thanks for the quick t...

Migration Wizard Appears to Generate Invalid T-SQL

first post: tycho_c wrote: I ran into an issue today running version 3.8. I just downloaded it...

SQLAzureMW 3.7.7 crashes when uploading...

first post: Alpicus wrote: Hi,Just subscribed to SQL Azure and downloaded SQLAzureMW 3.7.7 the...

latest post: Alpicus wrote: Hi George !Thanks for your reply. This works now like a charm.Cheer...

Unable to migrate database to Windows Azure

first post: mbiazure wrote: Hello,I am trying to migrate a database to Windows Azure using SQLA...

latest post: ghuey wrote: Hi Sandeep, The best way is to just find a non-production machine (...

Why was the source code removed from the repository?

first post: timerickson wrote: I went to check out the source to work on some modifications and as...

latest post: ghuey wrote: Just as an FYI for everybody, the source code is now tied back into...

Index Out of Bounds

first post: mikewiegand007 wrote: Hi,I desperately need this thing to work. Older versions worked gre...

latest post: mikewiegand007 wrote: u r a genius. That totally fixed it. Thank u very much!!!!!!!!!!!!!...

SQLAzureMWBatchBackup.Exe.Config Missing

first post: taktin wrote: Hi,First of all I want to thank Mr Huey and his team for this wonde...

latest post: ghuey wrote: Hi, That was my fault, I left SQLAzureMWBatchBackup.exe.config out ...

SqlAzureMWBatchBackup v1.2.4.0 'Value cannot be null.Parameter name: name'

first post: NeilT wrote: Running:SQLAzureMWBatchBackup -S xxx.database.windows.net -U admin@...

latest post: NeilT wrote: That's the one. Thanks for your help!

Index was outside the bounds of the array - Attempting to connect to SQL Azure DB

first post: Cavan wrote: I've been using the v3.6 Migration wizard but have started getting ...

latest post: Cavan wrote: Hi George,I have downloaded the SQL Server 2008 R2 SP1 Express upda...

ArgumentOutofRangeException while migrating through sql script

first post: surfel17 wrote: I am having ArgumentOutofRangeException while migrating DB from Azu...

latest post: ghuey wrote: Thanks, I added the config file and reuploaded the package.Thanks a...

Error when using SQLAzureMWBatchBackup

first post: oanaB wrote: Hello, I am trying to use SQLAzureMWBatchBackup command line to bac...

latest post: ghuey wrote: Hi, I think I found the problem when debugging another issue. Basi...

Migration Wizard and Raiserror oldstyle

first post: heinrich13 wrote: I'm using Migration Wizard v.3.7.4 to Analyze/Migrate my T-sql file...

latest post: heinrich13 wrote: Thank's alot, I will change this in the config file.

Lost EXEC Permissions

first post: HowardH wrote: I've migrated an on-premise DBMS via SQL Migration Wizard 3.7.4 to ...

latest post: ghuey wrote: Hi Howard, No, you didn't do anything wrong. Security is one thing...

Unable to use Azure Storage using Azure Compute

first post: mbiazure wrote: Hello all,I am new to Azure and I am trying out my first website on...

latest post: mbiazure wrote: Hey Ghuey, Thanks for your reply, but that did not help. I have ...

Copy table and data from local SQL Server 2008 to SQL Azure database

first post: mbiazure wrote: Hi all,I have the scripts generated by SQL Azure Migration Wi...

latest post: mbiazure wrote: hi ghuey,I was successful in migrating the data along with the tabl...

Migrating Data (.dat) from on-premise file system to SQL Azure

first post: wely wrote: First of all, thanks for delivering such a great tool to community ...

latest post: mbiazure wrote: Hi all,I have the scripts generated by SQL Azure Migration Wizard v...

System Tables

first post: Parasips wrote: Does the v 3.7.2 takes care of system tables, views and other syste...

latest post: ghuey wrote: Hi Paras, I check all objects and see if they are system objects. ...

Migrating Data Only - Table columns must be in same order

first post: dberkley wrote: When migrating "data only", if the columns within a table are in a ...

latest post: ghuey wrote: Hi,I use BCP to download and upload the data. If you look at SQLAz...

Using SQL Azure Migration Wizard in pt-BR

first post: fredskwara wrote: Hi there,We have been trying to use the wizard with the BCP output ...

latest post: ghuey wrote: Hi,Contact me via Codeplex and we can exchange email address and ta...

Error #: 40517 -- Keyword or statement option 'pad_index' is not supported in this version of SQL Server.

first post: craigwrdouglas wrote: Hi I have run the migration wizard, but all of my tables are reject...

latest post: craigwrdouglas wrote: That's great George, worked a treat.Craig

RowGuid suggestion

first post: n3wt0n wrote: Hi to all, it's my first post. Since the "RowGuid" table row proper...

latest post: n3wt0n wrote: I'm sorry... I've just noticed that the sw does it writing it on th...

SQLAzureMWBatch future plans

first post: Dweller wrote: Hi,Currently SQLAzureMWBatch saying:"Future release of SQLAzureMWBa...

latest post: ghuey wrote: Hi Amita, No, I had not thought of including multiple databases in ...

The data are not copied by the BCP utility despite the success of the summary of results

first post: ZaFoX47 wrote: Indeed,despite the fact that the Wizard is functioning properly and...

latest post: ZaFoX47 wrote: Exactly.I replaced the French BCP translation (in <fr-FR>) with the...

Scripting Data Only Disables All Constraints

first post: JamesCostello wrote: When using the Migration Wizard only to script out all data (in Adv...

latest post: ghuey wrote: Ok, I understand. Yes, this is a BCP issue I think, which you can ...

PathName is not supported

first post: msbigot wrote: Got this is the windows version of MW. Selecting just stored proce...

latest post: HowardH wrote: Please note that v 3.6 still has this issue. The T-SQL appears to ...

Using MW to Backup and Restore?

first post: scottseanjack wrote: Has anyone considered using the MW as a Backup and Restore tool? I ...

latest post: scottseanjack wrote: Thanks George. Keep me posted on your progress.

Thanks

first post: scottseanjack wrote: Thanks ghuey. Defo keep me up to date with your progress and thanks...

Don't copy data

first post: progs wrote: I try to copy the tables with data from azure to my local database....

latest post: progs wrote: Problem found: I've got a englisch Windows with languate set to ger...

Invalid object name 'dbo.Places'

first post: progs wrote: When I try to migrate an Azure DB to an SQL DB, the program will ab...

latest post: progs wrote: Hello,it seems to work fine now. thanks!

spatial index error

first post: mbabramo wrote: My database includes a spatial index. I was able to copy it to SQL ...

latest post: ghuey wrote: This looks to be an error with SQL Server Management Objects (SMO) ...

Tables not migrating - ON PRIMARY?

first post: HowardH wrote: Having trouble with CREATE TABLE. Some of my tables are not actual...

latest post: ghuey wrote: &#65279;Hi, SQLAzureMW should catch "ON [PRIMARY]" and remove it if...

BCP error when migrating from SQL Azure

first post: mbabramo wrote: I am trying to migrate my database from SQL Azure back to a local m...

latest post: ghuey wrote: Thanks for finding this problem. Basically, SQLAZureMW puts the wr...

Can't run it...

first post: robvig wrote: I've unzipped the download and clicked SQLAzureMW.exe (multiple tim...

latest post: ghuey wrote: Hi Robert,What version of SQL Server are you running on your databa...

Bug (v3.5.3): BCP connection password not escaped

first post: M_Parreira wrote: Hi,BCP will fail to connect if your password contains doublequotes ...

latest post: ghuey wrote: Ohhhh, great catch. I will put this suggestion in v3.5.4.Thanks, ...

SAMW v3.5.2 crash while generating script

first post: brianscottdavis wrote: SQLAzureMW has stopped workingWindows 7 x64 UltimateMigrate single ...

latest post: ghuey wrote: Hello Mr. Davis!I don't know if I fixed your specific problem, but ...

internationalization of applications

first post: norayuni wrote: If I 'll provide you Japanese language translation of the text mess...

latest post: ghuey wrote: SQL Azure Migration Wizardが、一つ目の国際言語、日本語へ対応したことを発表でき光栄です。大和屋貴仁が日本語へ...

Connection Error Problem

first post: SuperRoo wrote: Hi,I go through the whole process...log into azure to get my databa...

latest post: SuperRoo wrote: Hi again,fixed again...I was using V3.4.0....updated to V3.4.1 and ...

BCP Error

first post: SuperRoo wrote: Hi, I'm using SQLAzureMW to migrate a database but when it gets to ...

latest post: SuperRoo wrote: Fixed this problem...after doing some research I found that the Ver...

Some performance feedback and regex changes

first post: trentmswanson wrote: I would first like to add that this is a very useful tool and wonde...

latest post: ghuey wrote: &#65279;Hi, I just wanted to say thanks for the feedback on SQLAzur...

Script missing BCP commands!

first post: davideusai wrote: Hi All,I have a problem with the output script.When SQL Azure Migra...

latest post: davideusai wrote: Hi George,I come back from holiday and I work to project again. I ...

Port prerequisite

first post: blackmask wrote: Hi All, Do we need to have the outbound tcp port 1433 op...

latest post: ghuey wrote: Yes, you do.Regards, George

Import only subset of data

first post: aka wrote: Hello,it is possible to import only subset of data from local sql s...

latest post: ghuey wrote: Hi,From SQLAzureMW, I don't provide that functionality, BUT, you ca...

internationalization of applications

first post: norayuni wrote: If I 'll provide you Japanese language translation of the text mess...

internationalization of applications

first post: norayuni wrote: If I 'll provide you Japanese language translation of the text mess...

Migrate geography datatype to Azure

first post: lbobotimbo wrote: I have several tables in SQL 2008 R2 dbs that contain the geography...

latest post: ghuey wrote: Hi,I am using geography datatypes as well and I am not having any i...

Can't do the "run script" part due to login error

first post: ThomasHej wrote: Great tool and I used it before with success.But something must hav...

latest post: ghuey wrote: Ok, I made the fix. If try v3.4.1 and if it does not work, please ...

Support for automating data out from SQL Azure

first post: Code360 wrote: Hi,First of all, great tool, keep up the good work!I'm just wonderi...

latest post: ghuey wrote: Hi,No, SQLAzureMW or MWBatch does not do these things today. Do no...

Connection failure when trying to upload data to azure with bcp

first post: frank83 wrote: Hey,Debugging 3.3.8 I finally found out, why my Data uploads to azu...

latest post: ghuey wrote: Hmmmm, I tried it without the @servername and I got the prompt and ...

Download Azure DB structure & data

first post: bsavoie wrote: Wonderful tool, works great moving my db's up to the SQLAzure, but ...

latest post: ghuey wrote: This is good to hear!!! I am glad that everything is working!!!

bcp u/l into Azure fails on PK

first post: cfdevct wrote: Running SQLAzureMW, on just a cut-down sql file to test gave me thi...

latest post: cfdevct wrote: I was s/r the actual table details and missed one.My situation is I...

Infamous 'Could not find number of records copied. File will not be uploaded.' on all machines with latest build (3.3.9)

first post: ChristianWeyer wrote: Hi, we are having big trouble getting the latest release to run pro...

latest post: ChristianWeyer wrote: Just to add: version 2.1 works... hm...

support for processing vs10 dbproj .sql build output

first post: robertob wrote: In the vs10 release there is support for a file | new | database | ...

latest post: ghuey wrote: Thanks! I downloaded it and will check it out over the weekend. S...

BCP Output parsing (Internationalization)

first post: frank83 wrote: Hi,it would be a great benefit if you could manage bcp output regex...

latest post: frank83 wrote: Great job! Works like a charm! Regards, Frank

Downloading the source code?

first post: frank83 wrote: Hi,I downloaded the source code (link on the right) to analyze an i...

latest post: ghuey wrote: Ahhh yes, the code under the Source Code tab is old. I have not fi...