There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
SQLAzureMWBatchUpload cannot work against local SQL Server
I use SQL MW to download databazes from cloud locally from command line. When I try to use SQLAzureMWBatchUpload.exe in order to "upload" data to local SQL Server, I get the following error:
SQLAzureMWBatchUpload, Version 18.104.22.168
Unhandled Exception: System.Data.SqlClient.SqlException: Incorrect syntax near 'MAXSIZE'.
at SQLAzureMWUtils.TargetProcessor.CreateDatabase(TargetServerInfo targetServer, String collation, String edition, Int32 dbSize, Boolean bDropDatabaseIfExists)
at SQLAzureMWBatchUpload.Program.Main(String args)
I've checked the source code and the problem is that command line utility doesn't allow to specify server type and uses the default SQLAzure value of enum ServerTypes. If this utility is used to upload data to local SQL Server and it is going to create new
target database, it tries to attach MAXSIZE setting to the CREATE DATASE statement, which results in the mentioned error.
Is there possible to add one more command line argument (e.g. -Y) for setting target server type?
PS: I'v done the necessary modifications of the application in my local copy of source code myself (added -Y command line argument), but it would be better if this option is implemented in your release. Is there some way how to get this fix there or do I have
to wait while it is implemented on your side?