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

SQL Azure V12 - CREATE ASSEMBLY - UNSAFE

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: Jan 14 at 11:12 PM by cliffmcmanus | Created: Jan 14 at 11:12 PM by cliffmcmanus

Spurious Errors on Scripting Database

My database for export from SQL Server 2008 R2 has a lot of tables and stored procedures. I have two problems: Problem 1 The Migration Wizard is giving me the following error on just 6 stored pr...

Id #7938 | Release: None | Updated: Jan 2 at 7:58 AM by PatrickEllis | Created: Jan 1 at 2:32 PM by PatrickEllis

Null DateTime column values defaults to 1/1/1900

I realize this can be overridden with BCP; just wanted to mention it as it should not be the default.

Id #7908 | Release: None | Updated: Nov 8, 2014 at 3:26 PM by ycourbier | Created: Nov 8, 2014 at 3:26 PM by ycourbier

Sys.synonyms is not supported in current version of SQL Azure

Whilst generating the SQL script, it generates the following errors: Sys.synonyms is not supported in current version of SQL Azure DATABASEPROPERTYEX is not supported in current version of SQL Az...

Id #7900 | Release: None | Updated: Oct 9, 2014 at 5:13 PM by ghuey | Created: Oct 9, 2014 at 1:21 PM by oli_b