Comments
Sort by recent activity
Hi Brian,
Using the UI I got two comprehensible warnings: Severity: High
Object: Detail
Title: The column [MasterID] on table [dbo].[Detail] must be added but has no default and does not allow NULL values. The table must be rebuilt. If the table contains data then the migration script will not work. To avoid this, add a default to the column or mark it as allowing NULL values.
----------------------------------------------------
Severity: Medium
Object: Detail
Title: The column order in table [dbo].[Detail] has changed. The table must be rebuilt. The data in the table apart from dropped columns will be preserved.
----------------------------------------------------
The generated sync script by the UI comparing scripts folder vs scripts folder is the same as the generated sync script by the command line tool comparing scripts folder vs database.
We use the SQL Compare command line tool to generate delta scripts for our software product release in our release management system.
But sometimes the generated scripts are not usable as described in my first post.
Best Regards
Markus / comments
Hi Brian,
Using the UI I got two comprehensible warnings:Severity: High
Object: Detail
Title: The column [MasterID] on table [dbo].[Detail] must be added but has no default ...
Hi Brian,
yes, rebuilding of tables (e.g. for applying new column positions) is missing.
But the main problem is the missing Primary Key for newly added tables.
Best Regards,
Markus / comments
Hi Brian,
yes, rebuilding of tables (e.g. for applying new column positions) is missing.
But the main problem is the missing Primary Key for newly added tables.
Best Regards,
Markus