Posts
Sort by recent activity
Creating Foreign Key on a Table with missing Column
I tried to promote only new tables to the target database. SQL Compare added SQL in the script to add a foreign key to an existing table for a column that does not exist yet.
Other than modifying ...
Duplicate Drop\Create Foreign Key Statements
I compared a database with 750 tables. The generated script used to update the data created duplicate drops and create statements for the same foreign key. After deleting about a dozen of these s...
Cannot insert the value NULL into column
I am having a problem adding new columns to a table. The new table definition has new columns that are both NULL and NOT NULL.
The SQL Compare Script creates a temp table to contain data from the ...