Steps to migrate data from one SQL Server to another SQL Server when the Domains are different and connecting to another SQL server (say within a VM) from local SQL Server Instance isn’t feasible :
The wizard that helps migrate data for such a scenario would be the Generate Scripts Wizard as shown below:
Next, we would be selecting the tables and the data which we would want to move like below:
Next, provide the path for where you would want to save the generated scripts.
Next, click on “Advanced” and there choose what you would wish to migrate (like whether you would wish to migrate ‘Schema Only’ , ‘Data Only’, or ‘Schema and Data’)
Also, here if you choose any option which involves Schema, then correspondingly, you would need to choose DROP and CREATE option so that accordingly you can recreate the Source schema in Destination (only possible after Destination Schema is also Deleted to handle scenario where destination table already exists)
Finish these out and thereon you get the generated sql scripts in the path you specified earlier. You are now ready with running the generated scripts on the destination SQL Server.
Have a good day :)
Comments