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 12:42 PM by sachinpatel | Created: Jun 16 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 at 12:21 AM by ghuey | Created: Feb 9 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: Apr 20 at 2:10 AM by cpownall | Created: Feb 4 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 at 11:15 PM by ghuey | Created: Jan 20 at 6: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 11:34 AM by mkopec | Created: Oct 28, 2015 at 11:34 AM by mkopec

Filter list if things that will be scripted

Will be very nice if there will be filter so I can really fast find unwanted stored procedures or something else to uncheck them

Id #8037 | Release: None | Updated: Oct 2, 2015 at 10:51 PM by ghuey | Created: Oct 2, 2015 at 7:47 PM by mac2000

Remove filegroup from generated scripts

I have database with many file groups used on it, after trying to generate scripts and apply them to Azure SQL got many errors like: Error #: 1921 -- Invalid filegroup 'DATA' specified. Will be n...

Id #8036 | Release: None | Updated: Oct 5, 2015 at 7:56 AM by mac2000 | Created: Oct 2, 2015 at 7:46 PM by mac2000

Unable to set localdb as target server

I am trying to copy data from SQL Azure to LocalDB SQL Server v12.0.2000 and keep getting "The instance of SQL Server you attempted to connect to does not support encryption" error when trying to s...

Id #8035 | Release: None | Updated: Sep 25, 2015 at 3:01 AM by mcm_ham | Created: Sep 23, 2015 at 3:37 AM by mcm_ham

uploading against V12 fails, if there is no database

Hi, I have been using this tool for some time. Very practical. Thanks. We use SQLAzureMWBatchBackup and SQLAzureMWBatchUpload, to move databases Recently we upgraded to V12 and it stopped working. ...

Id #8034 | Release: None | Updated: Sep 18, 2015 at 2:39 PM by ghuey | Created: Sep 18, 2015 at 12:24 PM by azkamil

Getting object reference not set to an instance of an object error

Hi Team, I have downloaded "SQLAzureMW" code from codeplex. I got the zip file(sqlazuremw-73290) , I have extracted and opened it using visual studio2013. I have executed the code I am getting t...

Id #8028 | Release: None | Updated: Sep 3, 2015 at 1:39 PM by sujana123 | Created: Sep 1, 2015 at 2:53 PM by sujana123