John Baird
Coatesville, Pennsylvanie, États-Unis
Information générale
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement