SQLAzureMWBatchUpload cannot work against local SQL Server
description
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 3.9.1.0
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.Process()
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?