Can SQLAzureMWUpload upload to a SQL Server instead of SQL Azure

Jun 29, 2016 at 9:19 PM
We have a need for migrating content from a SQL Server to another SQL Server and I was wondering if the batch upload program can be used in this scenario.
If I use the GUI version I can certainly migrate from SQL Server to SQL Server but the batch upload program asks for SQL Server edition and sizes so I was not sure it supports uploading to SQL Server instead of SQL Azure.

Jun 29, 2016 at 9:33 PM

Yes, you should be able to go from SQL Server to SQL Server. Note that you might be better off using SQL Server tools, but you can do this with SQLAureMW (and tools). If I remember correctly what I do is connect to your target database and figure out is it is SQL Azure or SQL Server. If it is SQL Server, then I just ignore the SQL Azure parameters.