Posts
Sort by recent activity
FROM NULL TO NOT NULL, BUT WITH DEFAULT
I have a suggestion for a new option. Sometimes it happens, that we create a table like this:CREATE TABLE Test ( ID INT IDENTITY ( 1, 1 ), Field1 INT NOT NULL, Field2 INT NULL )
IN...
Options."DoNotUseALTERASSEMBLYToChangeCLRTypes"?
Hello,
how do I set the option "Do not use ALTER ASSEMBLY to change CLR types" in my code:Differences diffs = m_ReferenceDatabase.CompareWith(m_DatabaseToUpdate, Options.ForceColumnOrder );...
Wrong order in synchronization script
Hello,
with new SQL Server 2005 it's not possible to update our databases in one step anymore, because SQL Compare creates some functions in wrong order.
I have made a script for you to test. It cr...
API, integrate into own editor
Is there any possibility to integrate SQL Prompt into a self-written editor (with .net 2005)? Are there any APIs for that or something else?
Thank you,
Michael Kriegner
Comparison Key not set
I have two identical Databases (because of SQL Compare) and want to synchronise with SQL Data Compare. But in some tables the comparison key is not set. Why? What's the problem?
Thank you for any h...
Problem with CTE
When I synchronize a new, empty Database I get following error, because of a wrong executing order and I think, it's because of the CTE:
The following error message was returned from the SQL Server...