Comments
Sort by recent activity
I tried turning off the Include Dependencies but it did not help.
The foreign key will be added to existing table once the new column is added. Before that happens I need to create a new table whose primary key is contains the values for the new column on the existing table.
SQL Compare when creating a new table should not generate foreign keys on other tables. Instead these foreign keys should be create when those tables changes are promoted.
I tried promoting one table at a time but SQL Compare did not work. / comments
I tried turning off the Include Dependencies but it did not help.
The foreign key will be added to existing table once the new column is added. Before that happens I need to create a new table who...
Unfortunately the column definition must remain NOT NULL without a default.
The work around for me would be to specify a default value on the INSERT. I would use the system defaults like spoce, 0 or current_timestamp.
I am looking for a tool that will automate this as much as possible.
I have been using Embarcadero's Change Manager. But their product is slow and they do not offer a data compare tool so that is why I am looking at your products. It does handle columns defined as NOT NULL without a default properly / comments
Unfortunately the column definition must remain NOT NULL without a default.
The work around for me would be to specify a default value on the INSERT. I would use the system defaults like spoce, 0 ...