John Baird
Coatesville, Pennsylvania, United States
General information
Forum:
Microsoft SQL Server
>>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.
Thanks, I was afraid that restoring and then copying would cost a lot more but maybe not. I'll check.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only