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 at 1:08 AM by ghuey | Created: Nov 17 at 12:55 PM 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 at 3:11 PM by SupportAntusa | Created: Oct 10 at 3: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 at 8:30 PM by ghuey | Created: Jul 6 at 6: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 at 8:22 PM by ghuey | Created: Jul 4 at 11: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 at 8:19 PM by ghuey | Created: Jul 4 at 11: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 at 1:42 PM by sachinpatel | Created: Jun 16 at 12:16 PM 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 at 1:21 AM by ghuey | Created: Feb 9 at 3: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: Apr 20 at 3:10 AM by cpownall | Created: Feb 4 at 2: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 21 at 12:15 AM by ghuey | Created: Jan 20 at 7:39 PM by vjudragon

Aggregate functions are not being migrated

Currently aggregate functions are skipped when scripting all database objects. They are also invisible in 'User Defined Functions' node if you want to select specific objects.

Id #8044 | Release: None | Updated: Oct 28, 2015 at 12:34 PM by mkopec | Created: Oct 28, 2015 at 12:34 PM by mkopec