Migrait Multiple databases to Rds or Azure

Dec 16, 2014 at 9:54 AM
Does this tool have an option to migrate more then one database?
Coordinator
Dec 16, 2014 at 3:48 PM
Hi,

Not, not in SQLAzureMW. It is built to walk you through one at a time. That said, I do have SQLAzureMWBatchBackup and SQLAzureMWBatchUpload which do the same thing, but are command line driven. You could easily create a .bat file that you can put in several one line commands to migrate as many databases as you want.

Regards,
George
Dec 25, 2014 at 10:31 AM
I dont see the SQLAzureMWBatchBackup.config file in the downloaded zip...
Dec 25, 2014 at 10:47 AM
BCP.exe is also missing
Dec 25, 2014 at 1:02 PM
OK managed to work , looks great ,
How can i migrate the db users and logins
Coordinator
Dec 25, 2014 at 4:02 PM
You will have to script users and logins from SQL Server and then run them on your target database. Check out http://msdn.microsoft.com/en-us/library/azure/ee336235.aspx

Regards,
George
Dec 25, 2014 at 4:04 PM

Thanks

Best Regards,

Yariv Attar

Customer Success

M +972.54.6503153

image001

Make your Bootstrap come alive

www.backand.com