SQL Azure Migration failed

first post: tech_live wrote: I ran the SQL Server Migration wizard to upload a 250GB database to...

latest post: tech_live wrote: Hi George, Quick question, thought you might be able to help here...

Automate SQL Databse Migration Wizard

first post: lelias1 wrote: Is there a way to have the wizard run unattended and on a regular s...

latest post: lelias1 wrote: Hi George, Thanks for your reply. Actually I was also thinking of ...

Can SQLAzureMWUpload upload to a SQL Server instead of SQL Azure

first post: rsingh wrote: We have a need for migrating content from a SQL Server to another S...

latest post: ghuey wrote: Hi, Yes, you should be able to go from SQL Server to SQL Server. ...

SQLAzureMWBatchBackup fails but SQL Azure Migration Wizard runs

first post: rsingh wrote: I have been using SQL Azure Migration Wizard successfully to migrat...

latest post: rsingh wrote: I was running the wrong version of SQLAzureMWBatch. I began using t...

Support for Full Text Search Migration

first post: lFamson wrote: Thanks for this wonderful tool. It is definitely making a differenc...

Issue with BCP

first post: ktrock wrote: Hello. I forget the options I chose in the wizard; it got the objec...

latest post: ktrock wrote: OK, worked now. Not sure why I couldn't connect earlier. The Migrat...

SQL Server 2016 Upgrade Advisor, no longer exists?!

first post: LeeC wrote: Does anyone know where I can download it? The link on this project...

latest post: ghuey wrote: Hi Lee, The link for SQL Server 2016 Upgrade Advisor Preview 1.4 i...

Issue with ReadOnly user

first post: bthomason wrote: How can I pull data from one database using a Read Only user? When ...

latest post: ghuey wrote: Hi, SQLAzureMW was designed to only let DB owners copy and migrate...

Clustered indexes 'missing' on lookup tables

first post: bmather wrote: Hi, Thanks for creating such an awesome tool. I really like the U...

latest post: bmather wrote: Thanks again George. That fixed it. I've managed to ship my first ...

How to migrate table rows

first post: instagib1 wrote: By using the migration wizard, it successfully migrates tables, but...

latest post: instagib1 wrote: It seems bcp.exe is missing, where can I download it? Edit: found ...

Access only allowed using a security-enabled connection string

first post: bmather wrote: Hi, I am trying to connect to my Target Azure SQL server and am g...

latest post: bmather wrote: Perfect, that works - and I understand why!

answered by: ghuey wrote: Hi, Do you have auditing turned on for your Azure SQL DB? If so, ...

USERS and GRANTS

first post: BlackNGoldTMS wrote: I just tested this for the first time (Migrating from SQL 2012 to 2...

latest post: ghuey wrote: Hi Travis, No, you are not missing anything. That is one thing th...

restart data transfer

first post: thatoneguy1 wrote: I was transferring a 60 gb database. My machine lost it's network ...

latest post: ghuey wrote: Yes. You know when you first go through SQLAzureMW, you choose the...

Script Wizard take a lot of C Drive space.

first post: subhash1507 wrote: Hi There, I am running Azure v5.15.6 tool for migrating 100GB SQL...

latest post: ghuey wrote: Hi Subhash, It could, it depends on how much data you have per row...

Bulk Copy Error: Violation of PRIMARY KEY constraint

first post: trevorjdaniel wrote: I am getting a strange error when uploading a table with 1.8m recor...

latest post: ghuey wrote: Hi Trev, Check out the following thread: [Old Codeplex thread](htt...

Failing without error messages?

first post: jrichview wrote: Quarterly for years I've been running SQL MW to migrate a bunch of ...

latest post: ghuey wrote: Hi, I have not seen this issue. Out of curiosity: 1) What versio...

Create indexes after loading data

first post: sberkovitz wrote: With really large tables, it is more performant to create non-clust...

latest post: ghuey wrote: Thanks for your input. Definitely something worth looking into. T...

Any alternate for inbuilt functions like master.dbo.fn_varbintohexstr

first post: ARUN44VIJAY wrote: Inbuilt functions like master.dbo.fn_varbintohexstr is not supporti...

latest post: ghuey wrote: Hi, I see fn_varbintohexstr in Azure SQL DB. Have you tried leavi...

Can you make it read from Excel and then push to Azure Sql

first post: jask2002 wrote: This is new feature request. This tools is great but seems like it...

Any alternate for inbuilt functions like master.dbo.fn_varbintohexstr

first post: ARUN44VIJAY wrote: Inbuilt functions like master.dbo.fn_varbintohexstr is not supporti...

SP's in my SQL Azure Db is throwing word breaking errors.

first post: ARUN44VIJAY wrote: Hi, I am getting the below error frequently when executing my SP'...

latest post: ARUN44VIJAY wrote: Thanks its resolved now after providing bumping resource. Thanks, ...

How to use Cross database table in Azure?

first post: ARUN44VIJAY wrote: Happy New Year all :) In my trigger a other database table has be...

latest post: ARUN44VIJAY wrote: Thanks Lonny, I will try this for my case and get back here for any...

HOW TO IMPORT A 43 MILLION RECORD IN SQL AZURE

first post: ARUN44VIJAY wrote: Need to migrate a table having 43 million records from SQL server t...

latest post: ARUN44VIJAY wrote: Sorry for the delayed response. It worked after changing the BCP se...

SQLAzureBatchMWBackup error AWSRDS->disk->AWSRDS

first post: akaczorek wrote: I am attempting to automate a backup of an RDS database using the c...

latest post: bvaspect wrote: Hi George, Thank you so much for your response. We have the b...

Reference to database and/or server name in 'master.dbo.syscharsets' is not supported

first post: mdegre wrote: Hi all, We are currently trying to migrate our data from on premi...

How to update SQL Azure DB using SQLAzureMW

first post: zj0331 wrote: Hi folks, I have successfully import a database from my SQL serve...

latest post: ghuey wrote: Hi Ji, I had this question the other day. See: https://sqlazuremw...

Ability to re-run migration and keep data in sync

first post: hiraldesai wrote: Hi, I am working on a migration project for a very old and big ap...

latest post: hiraldesai wrote: Thank you very much - I will give it a go!

Target Server

first post: Nitramueth wrote: Hello, quick question: In Target Server selection... is the "SQL ...

latest post: ghuey wrote: Hi, it is an Azure target DB (the latest Azure SQL DB). Regards, G...

Is there a way to split the export/import across 2 machines?

first post: mberneis wrote: In my environment the SQL server does not have access to the intern...

latest post: ghuey wrote: Hi Michael, I am so sorry for the late reply. The answer is yes, ...

Error Scripting Azure Table

first post: jschjol wrote: I'm trying to migrate an Azure database to a local SQL Server datab...

latest post: ghuey wrote: I am glad you are up and running! Have a great day!

Exception thrown: 'System.MissingMethodException' in SQLAzureMW.exe

first post: mbv1234 wrote: When running the application I keep getting the error below when hi...

latest post: ghuey wrote: Hi, Sorry, I didn't get notified of this post. No, I have not see...

SQLAzureMWBatchUpload Config - use RAW input?

first post: paschott wrote: So our current process uses BatchBackup to generate the files, then...

latest post: paschott wrote: George, Thanks for your patience. I think we actually did have th...

Semaphore timeout period expired

first post: Srivani wrote: Hi, I am trying to migrate data from one DB to another with billi...

latest post: ghuey wrote: Hi Srivani, What service tier are you trying to upload to? It is ...

Exception part way though uploading data

first post: JohnTankard wrote: Hi I am running the wizard to migrate a SQL database, all appears t...

latest post: ghuey wrote: Hi John, Yea, the work around at this time would be to rename the ...

How to start program?

first post: SteveLoehrke wrote: Downloaded SQLAzureMW v5.15.5 for SQL Server 2014. Unzipped. Now ...

latest post: ghuey wrote: Hi Steve, You are too kind. I am very glad you are up and running...

How important is the SQL Profiler Trace File Analysis?

first post: steveorrmvp wrote: The SQLAzureMW SQL Profiler Trace File Analyzer is immediately cras...

latest post: ghuey wrote: Hi, I found a bug in the code when writing out status messages and...

What happened? Only schema was migrated, no data. :(

first post: sandomar wrote: I ran the migration wizard for a database from SQL Server 2014 to S...

latest post: ghuey wrote: Hi Sandy, I will contact you offline and we can walk through the p...

Gettin Error "Object reference not set to an instance of an object."

first post: scubaduba wrote: Hi, I have a database on Azure SQL. We need to script data and migr...

latest post: scubaduba wrote: I don't have a machine with SQL Server 2014 but I can give you user...

Playing with migrations tarting v12: everything is supported !

first post: styx31 wrote: I am trying to list all the things actually not supported in v12. A...

latest post: ghuey wrote: Hi, Just wanted to let you know that I went through a lot of the r...

Is it possible to filter data for copying?

first post: eivindbjarte wrote: I have a database where most tables have a tenantId. I would lik...

latest post: ghuey wrote: Yes. After you select the database you want to migrate, a "Choose ...

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: edgarecayce wrote: Hi I am having same issue. I am using the SQL Server 2014 version....

SQLAzureMWBatchBackup - Operation not supported on version 11.0.9228 SqlAzureDatabase

first post: cliffmcmanus wrote: George Many thanks for this tool. I used it with great success for...

latest post: ghuey wrote: Out of curiosity, have you tried SQLAzureMW v5.15 and see if the GU...

Issues Migrating Azure SQL to SQL Server Local

first post: chadwixk wrote: AzureSQLWM: 4.15 SQL Server 2012 Most of what I can find on this...

latest post: ghuey wrote: :-). I am glad you are up and running!

answered by: chadwixk wrote: SOLVED! I am an idiot. This worked fine. What I didn't see was aft...

Migrait Multiple databases to Rds or Azure

first post: yarivat wrote: Does this tool have an option to migrate more then one database?

latest post: yarivat wrote: Thanks Best Regards, Yariv Attar Customer Success M +972....

Basic edition in SQLAzureMWBatchUpload

first post: azkamil wrote: Hi, thanks in advance for a great tool, which is really fast. I a...

latest post: ghuey wrote: Hi Kamil, Ok, I posted the fix today. Check it out and please let...

*= and =* operators can not run on sql 2012

first post: pvkt3588 wrote: Hi, I not sure mean of above 2 operators, and it can not run on s...

latest post: pvkt3588 wrote: Thanks ghuey!

DB analysis - Strange "not supported in Azure"

first post: Aresmarte1 wrote: Hi There, I'm analyzing some DBs to plan the migration on Azure. ...

latest post: ghuey wrote: Hi, I just wanted to check back with you and see how things were g...

"Include If Not Exist" does not work in v5.0.1

first post: Jericho wrote: When I set the "Include If Not Exist" advanced setting to "True", t...

latest post: ghuey wrote: Hi Jericho, The quick answer is that SQL Server 2014 SMO has a def...

Compatibility With Sql Server 2014 ?

first post: pbrundage wrote: Is version 4.0.1.8 compatible with Sql Server 2014? I'm getting th...

latest post: Kounadisk wrote: Hi George, I just tried 5.0.1 and everything works as expected! No...

Error 40552 large table upload to Azure

first post: juhlbyrider wrote: Hello, I am migrating a DB with a very large table and I keep get...

latest post: juhlbyrider wrote: Hello George, Adjusting the batch size to 5000 did the trick, it d...

Encoding issue

first post: prgjonas wrote: Hi, thanks for a great tool! However, I had a problem migrating a...

latest post: ghuey wrote: Hi, You need to play with the BCP parameters. Edit SQLAzureMW.exe...

SQL Azure and Migration Wizard

first post: lucmauri wrote: Running SQL Database Migration Wizard tool I got the following erro...

latest post: ghuey wrote: Hi Luca, There is no work around for the errors reported above. M...

naming of codeplex project and executable

first post: robertob wrote: the sql database migration wizard seems more than happy to drive mi...

latest post: robertob wrote: thanks for the background details that helps. any pointers to the ...

migrating from sql localdb to azure sql

first post: robertob wrote: does this tool, or any other one, support migrating from the defaul...

latest post: ghuey wrote: Hi, In truth, I never really thought much about localdb. I was mo...

Sorry, but the dependencies for SQLAzureMW are missing.

first post: robertob wrote: I downloaded the current sqlAzureMw, so I could migrate my sql loca...

latest post: robertob wrote: status update, this error arose downloading and using the v3.9.15 d...

Copy Data from Existing DAT files

first post: tspencer wrote: I have a folder of .dat files. I want to tell MW to copy the data ...

latest post: tspencer wrote: Thank you George, for that guidance and the great tool you have cre...

Migration to work out of Source Files

first post: koraman wrote: As far as I know, this migration wizard works out of a database. Is...

latest post: ghuey wrote: Hi, I believe that the answer is no. I don't specifically parse C...

Failing to Connect to SQL Azure....

first post: ESSB wrote: Hi, Trying to use SQLAzureMW to migrate my MSSQL2008 R2 DB to SQL ...

latest post: ESSB wrote: George, Thanks for this. I was actually running SP1 all the time. J...

Optional WHERE clause when copying data

first post: jreate wrote: Hello, How bad would it be to add an optional "WHERE" clause when...

latest post: ghuey wrote: Hi, It could be done but it would be a major change to how I have ...

Issues with porting ASP.NET Membership tables, procs, users and roles to Azure with SQLAzureMW?

first post: ESSB wrote: Hi, Great tool. However I have had a lot of problems trying to de...

latest post: ESSB wrote: Hi George, Thank you for this. On further investigation, I found ...

Incremental data changes?

first post: Esto wrote: Good day, Would it be possible to do incremental updates between ...

latest post: Esto wrote: Hi George, Thank you for your thorough response. I have to think a...

No Data

first post: geoffbeaumont wrote: I'm having some trouble getting SQL Database Migration Wizard to wo...

latest post: ghuey wrote: Oh, as a side note, if you have many versions of SQL Server install...

Support fan out scripts to all federations

first post: stevozilik wrote: Hi, 1) fantastic job all of this 2) would be great if we could...

latest post: ghuey wrote: Hi, Thanks for the kind words. In regards to executing SQL agains...

Missing Microsoft.ExceptionMessageBox

first post: JohnKrumm wrote: I downloaded this tool to my Windows 8 PC. Two problems: The "Down...

latest post: ghuey wrote: Hi, I am glad you got it working. Let me know if you run into any...

Automate validation of scripts at command line

first post: robertbird wrote: Hi, I am trying to setup a stage in my automated build/deployment...

latest post: robertbird wrote: Thanks George. That's amazing, I really appreciate your help! I ...

How are "Foreign keys" and "Triggers" handled?

first post: TariqYousaf wrote: Hi First I must appreciate your great effort. Your tool has a lot...

latest post: TariqYousaf wrote: Thanks for the detailed explanation George. That perfectly is the a...

Performance

first post: gimlichael wrote: Hi there, I am curious to how you achieve so excellent performanc...

latest post: gimlichael wrote: ghuey wrote: Note that even if you cache for one or two minutes, o...

SQLAzureMWBatchUpload hangs on error and does not return to prompt

first post: FunOne35i wrote: Here is how I generate the error. I did it on purpose but still won...

latest post: ghuey wrote: Hi Mark, I will see if I can't get it uploaded today. But for now...

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: Hi, SQLAzureMW should not drop FK constraints. Were the constrain...

SQLAzureMWBatchBackup v4.0.15 causes Failed to connect.

first post: SenHarada wrote: I think the follwing line at Process in Program.cs must be uncommen...

latest post: SenHarada wrote: Now I understand. We have to use the Azure SQL *server's* login. I ...

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 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 ...