Comments
Sort by recent activity
Hi Demian,
Please see my direct mail to you / comments
Hi Demian,
Please see my direct mail to you
Hi there,
Can you email us at support@red-gate.com and we'll send you a trial extension code back to help with this problem. / comments
Hi there,
Can you email us at support@red-gate.com and we'll send you a trial extension code back to help with this problem.
Hi,
SQL Compare shouldn't have forgotten to add the default, it should add it as a constraint further down the script.
The problem here is that changing a column that has NULL data in it to a NOT NULL column will fail, even if a default is associated with it. This is because SQL Server will not convert the existing NULLs to your default automatically.
The only thing that can be done is to write a script to update the NULL values to your specified default value, and run it against the destination database before the SQL Compare script is run. For Example:
UPDATE [dbo].[Institute] SET [ProvTeilungstag] = 0 WHERE [ProvTeilungstag] = NULL / comments
Hi,
SQL Compare shouldn't have forgotten to add the default, it should add it as a constraint further down the script.
The problem here is that changing a column that has NULL data in it to a NOT N...
Hello,
This seems very strange. Could you post up the creation script for the tables in question so that we can reproduce this anomoly. / comments
Hello,
This seems very strange. Could you post up the creation script for the tables in question so that we can reproduce this anomoly.
Hi there,
Unfortunately we have no plans to implement that kind of functionality at current. / comments
Hi there,
Unfortunately we have no plans to implement that kind of functionality at current.
Hi,
This can happen if you Data Compare, then add a new column to both tables and then Data Compare again. The reason is that it remembers what columns you have selected for a comparison per table and thus a new column is not going to be part of that list.
You can remedy this by selecting the column by clicking the "columns" column in the grid on the "select tables and views" dialog. / comments
Hi,
This can happen if you Data Compare, then add a new column to both tables and then Data Compare again. The reason is that it remembers what columns you have selected for a comparison per table ...
Hi there,
If you have already activated you toolkit then you will not get prompted again to enter the licence information. Can you check to see if a Toolkit.lic file has been created? The existance of that ile will verify that everything is working OK. / comments
Hi there,
If you have already activated you toolkit then you will not get prompted again to enter the licence information. Can you check to see if a Toolkit.lic file has been created? The existance...