Using SC I'm trying to create a new table AND copy the data over, how do I do this? Example below:
DB1 (dev db)
DB2 (prod db)
SC obviously gives me the differences between the two DB's, and as such I get a merge on T1 and T2, and a new create script on T3. However, T3 ha some static data in it that I need pushed to DB2. I tried to use SQL Data Compare and it states that there is nothing to compare it to so I cannot copy those rows.
How does one do this?
Also, to complicate it more, T3 now has a FK in T2. So a column is added to T2 with a default of ID 1(which ID 1 will exist in T3)...so when the merge script runs on T2, the T3 FK column should be populated with ID 1. How is this accomplished?