John Baird
Coatesville, Pensilvânia, United States
General information
Fórum:
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
Responder
Visualizar o mapa desta thread
View the map of this thread starting from this message only
Visualizar todas as mensagens desta thread
Visualizar todas as mensagens desta thread a partir desta mensagem