How do I migrate table structure with data from server to server?

DWilli

I know how to migrate table structure using SQL Compare and I know how to migrate data using SQL Data Compare.  I want to have a script to do both.

LubosM

Hi Dwilli,

As it's possible to script out both SQL Compare and SQL Data Compare with the command line, you can create your own custom Powershell script chaining both command line scripts.

SQL Compare Command Line

SQL Data Compare Command Line

DWilli

The table exists in UAT but not in production.  SQL Data Compare will not map the new table.  Message indicates to ensure the comparison keys are set correctly, which the product won't let me set the comparison keys.  I want to create both scripts before implementing.