Activity overview
Latest activity by dbirdil
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 ...
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...
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 ...