2008 and ODBC driver issue?

I have successfully migrated SQL 2012 DBs using SQLAzureMW v5.15.6 Release Binary for SQL Server 2014 However, I now need to migrate a SQL 2008 R2 DBs and I am running into problems??? Pre Requisi...

Id #8150 | Release: None | Updated: Feb 14 at 1:55 AM by ghuey | Created: Jan 5 at 4:12 PM by markaffinity

SQLAzureMWBatchBackup: unable backup external data source and external tables

Hello Colleagues, I'm doing backup of SQL Azure DB. In that DB we have external data source (Elastic Database queries, type RDBMS) and external tables. We have 3 issues here: External data sour...

Id #8142 | Release: None | Updated: Nov 18, 2016 at 12:08 AM by ghuey | Created: Nov 17, 2016 at 11:55 AM by lexikua

Out of Memory Exception

What are the limitations on the DB size? I've got this exception when migrating a 100+GB database: Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: SQLAzureMW.exe Problem...

Id #8136 | Release: None | Updated: Oct 10, 2016 at 2:11 PM by SupportAntusa | Created: Oct 10, 2016 at 2:11 PM by SupportAntusa

Moving only certain rows from a table

We are moving our desktop applications to cloud. From time to time we want to migrate the data from the local on-premise server to cloud. I am using this SQL migration tool and it works beatutifull...

Id #8128 | Release: None | Updated: Jul 7, 2016 at 7:30 PM by ghuey | Created: Jul 6, 2016 at 5:25 PM by TkNeo

Exception: Microsoft.SqlServer.Management.Smo.UnknownPropertyException

Microsoft.SqlServer.Management.Smo.UnknownPropertyException: AssemblyName: unknown property. at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException...

Id #8127 | Release: None | Updated: Jul 5, 2016 at 7:22 PM by ghuey | Created: Jul 4, 2016 at 10:07 AM by justinmann

Next button is disabled on "Select Source" page

Steps: Analyze/Migrate: Database Fill in DB and press connect Wait for DB list to download Select any DB, Next button stays disabled If I click back, then next it returns to this the "Select So...

Id #8126 | Release: None | Updated: Jul 5, 2016 at 7:19 PM by ghuey | Created: Jul 4, 2016 at 10:06 AM by justinmann

How to export sql data objects in .sql file using bcp?

Hi, I am able to export the data using below command. bcp "[learn].[dbo].[Account_]" out "c:\SQLAzureMW\BCPData\dbo.Account_.dat" -E -n -C RAW -S XXX.XXX.XXX.XXX -U "XXX" -P "XXXX" Then I tried...

Id #8093 | Release: None | Updated: Jun 17, 2016 at 12:42 PM by sachinpatel | Created: Jun 16, 2016 at 11:16 AM by sachinpatel

VIEW SERVER STATE permission was denied

Hello, First off, great program! We deal with a lot of remote databases so it's been very helpful for taking backups and copying data. I ran into an issue with a remote database where we were gi...

Id #8064 | Release: None | Updated: Feb 10, 2016 at 12:21 AM by ghuey | Created: Feb 9, 2016 at 2:34 PM by dilettante

Failed to connect to server

Having an issue with SQLAzureMWBatchBackup. When attempting to run the SQLAzureBatchBackup on an Azure Database for backup (download) I received the error: Failed to connect to server MYDBNAME_....

Id #8063 | Release: None | Updated: Dec 8, 2016 at 3:49 PM by clns | Created: Feb 4, 2016 at 1:42 AM by cpownall

Add First and Last Row count criteria for tables (i.e. BatchSize)

This functionality can be useful, when table consisting of 9 million records and we can set 1 million batch size for .DAT file. Then this task can be split into 9 async processes. Thank you.

Id #8059 | Release: None | Updated: Jan 20, 2016 at 11:15 PM by ghuey | Created: Jan 20, 2016 at 6:39 PM by vjudragon