How can we help you today? How can we help you today?

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

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.
Daryl Williams
0

Comments

2 comments

Sort by
  • 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.



    LubosM
    0
  • 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.
    DWilli
    0

Add comment

Please sign in to leave a comment.