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:
| Updated: Nov 18 at 1:08 AM by ghuey | Created: Nov 17 at 12:55 PM by lexikua
What are the limitations on the DB size? I've got this exception when migrating a 100+GB database:
Problem Event Name: CLR20r3
Problem Signature 01: SQLAzureMW.exe
Id #8136 | Release:
| Updated: Oct 10 at 3:11 PM by SupportAntusa | Created: Oct 10 at 3:11 PM by SupportAntusa
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:
| Updated: Jul 7 at 8:30 PM by ghuey | Created: Jul 6 at 6:25 PM by TkNeo
Microsoft.SqlServer.Management.Smo.UnknownPropertyException: AssemblyName: unknown property.
Id #8127 | Release:
| Updated: Jul 5 at 8:22 PM by ghuey | Created: Jul 4 at 11:07 AM by justinmann
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:
| Updated: Jul 5 at 8:19 PM by ghuey | Created: Jul 4 at 11:06 AM by justinmann
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:
| Updated: Jun 17 at 1:42 PM by sachinpatel | Created: Jun 16 at 12:16 PM by sachinpatel
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:
| Updated: Feb 10 at 1:21 AM by ghuey | Created: Feb 9 at 3:34 PM by dilettante
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:
| Updated: Apr 20 at 3:10 AM by cpownall | Created: Feb 4 at 2:42 AM by cpownall
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.
Id #8059 | Release:
| Updated: Jan 21 at 12:15 AM by ghuey | Created: Jan 20 at 7:39 PM by vjudragon
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:
| Updated: Oct 28, 2015 at 12:34 PM by mkopec | Created: Oct 28, 2015 at 12:34 PM by mkopec