>I need to move about .75 million records from sql server 2014 to a table in azure. What's the easiest way to do this? Backup is not possible as the databases are dissimilar. I just need to move certain tables. I tried scripting the data, but the query window chokes on so many records.
First way:
1. Make backup.
2. Restore on Azure (as different DB)
3. Move records from one DB to another.
4. Delete DB.
Second way:
1. Make a linked server
2. Move records from one DB to another.
3. Delete linked server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.