BCP file not found

I'm trying the new version to move some tables from 2014 to Azure, but I'm getting the following error. Process started at 5/3/2015 12:22:00 AM -- UTC -> 5/3/2015 4:22:00 AM ... Using BCP to get ...

Id #7995 | Release: None | Updated: May 5 at 1:58 AM by ghuey | Created: May 3 at 4:30 AM by jmathis

OpenXml now supported

I ran SqlAzureMW against my database and the following issues were reported: sp_xml_preparedocument is not supported in current version of Azure SQL Database sp_xml_removedocument is not supported...

Id #7992 | Release: None | Updated: Apr 23 at 2:09 PM by ablake | Created: Apr 23 at 1:43 PM by ablake

BCP invalid password escaping

BCP command fails when password contains invalid characters such as: [] {}() , ; ? * ! @ If you don't mind, will be very helpful to escape passwords automatically when invalid character were found...

Id #7991 | Release: None | Updated: Apr 20 at 4:21 PM by ganniaiuei | Created: Apr 20 at 1:02 PM by ganniaiuei

Save migrations for reuse

More of a feature request than an issue. Love this tool. Any chance to be able to save & reuse a migration? I'm no DBA so I hate some of the native MSSQL tooling, I prefer to use this tool for s...

Id #7973 | Release: None | Updated: Mar 18 at 7:37 PM by ghuey | Created: Mar 18 at 6:31 PM by BillMcCrary42

Object reference not set to an instance of an object.

Hi, I am trying to import data from SQL Azure to SQL Server but I am keep getting this error. "Object reference not set to an instance of an object." Thanks, Attiqe

Id #7963 | Release: None | Updated: Feb 27 at 10:13 PM by ghuey | Created: Feb 25 at 10:41 PM by attiqeurrehman

Invalid statement is generated for SQL Azure v12 Partitioned tables

When generating SQL Script from a partitioned table, this is the result SQL statement (notice the extra closing parentheses at the end): CREATE TABLE [dbo].[AuditBase]( [AttributeMask] [nvarchar]...

Id #7959 | Release: None | Updated: Feb 20 at 11:14 PM by ghuey | Created: Feb 17 at 12:07 AM by shovhannes


Error #: 40517 -- Keyword or statement option 'unsafe' is not supported in this version of SQL Server. CREATE ASSEMBLY [FooBarSqlClr] FROM 0x4D5A90000300000... WITH PERMISSION_SET = UNSAFE Since...

Id #7958 | Release: None | Updated: Feb 20 at 11:20 PM by ghuey | Created: Feb 16 at 11:35 PM by shovhannes

Syntax error in drop database

In version 5.15 the MigrationWizardBatchUpload does not work if the database name is a guid and already exists on the destination server. As workaround square brackets can be added in line 83 of th...

Id #7944 | Release: None | Updated: Jan 21 at 7:19 PM by ghuey | Created: Jan 19 at 2:38 PM by spliffbanana

Specify target folder

Instead of sticking everything into C:\SQLazureMW can we have just a target folder in the GUI?

Id #7943 | Release: None | Updated: Mar 17 at 10:42 AM by lareeth | Created: Jan 18 at 6:48 AM by oliverjanik

SQLAzureMWBatchBackup - Operation not supported on version 11.0.9228 SqlAzureDatabase.

George Many thanks for this tool. I used it with great success for over a year to copy my production database down from Azure to a local database for Q/A purposes. I have a new PC and had to reinst...

Id #7941 | Release: None | Updated: Mar 30 at 9:38 AM by AtA2k | Created: Jan 14 at 11:12 PM by cliffmcmanus