Activity overview
Latest activity by Oleg
Hi Michelle,
this is a last started query
SELECT so.name AS TableName,
sys.schemas.name AS TableOwner,
cc.name AS ConstraintName,
cc.object_id AS Constraint_id,
cc.is_not_for_replication AS NotForReplication,
cc.is_not_trusted AS WithNoCheck,
cc.is_disabled AS Disabled,
sc.name AS ColumnName,
cc.parent_column_id AS colid,
cc.definition AS Text
FROM sys.check_constraints cc WITH (NOLOCK)
INNER JOIN sys.objects so WITH (NOLOCK) ON so.object_id=cc.parent_object_id
LEFT JOIN sys.schemas WITH (NOLOCK) ON sys.schemas.schema_id=so.schema_id
LEFT JOIN sys.columns sc WITH (NOLOCK) ON sc.column_id=cc.parent_column_id AND sc.object_id=cc.parent_object_id
ORDER BY so.name, cc.name
These are results of executing query by the same user as in SQLCompare
intfiles dbo CK_intfiles 162815642 0 0 0 type 3 NULL
These results under sa:
intfiles dbo CK_intfiles 162815642 0 0 0 type 3 ([type] = N't1' or [type] = N't2' or [type] = N't3')
profile_types dbo CK_profile_types 1075691080 0 1 0 type_id 3 ([type_id]>(0) AND [type_id]<=(9)) / comments
Hi Michelle,
this is a last started query
SELECT so.name AS TableName,
sys.schemas.name AS TableOwner,
cc.name AS ConstraintName,
cc.object_id AS Constraint_id,
cc.is_not_for_replication AS NotForR...
New Project
I filled Source and Target datasource information and clicked Compare Now.
All data for the Source db was read (I waited some time) and then I've received an error because the second db requires s...
Databases combobox
In my opinion this is not comfortable to fill combobox with all existing databases, I think user needs online databases only.
For example, I have 30 databases on my server, 10 of them have state Of...
Registering database
I try to create a New Project.
During the database registering I have got:
mydb-Reading constraints
An unexpected null value has been encountered while queriyng the database system tables. Please m...
Hi Dan,
oh, it seems will be very useful product.
Btw, are you going to send some gifts for beta testers?
Regards,
Oleg. / comments
Hi Dan,
oh, it seems will be very useful product.
Btw, are you going to send some gifts for beta testers?
Regards,
Oleg.
Hi,
after patching its working good. I checked all ways.
Regards / comments
Hi,
after patching its working good. I checked all ways.
Regards
Hi Andras,
I'd like to add: SQL compare 5 is working good in my case but SQLCompare 6 is not.
Are useful catched queries?
Regards,
Oleg. / comments
Hi Andras,
I'd like to add: SQL compare 5 is working good in my case but SQLCompare 6 is not.
Are useful catched queries?
Regards,
Oleg.
Hi Andras,
I will try to catch this.
Regards,
Oleg. / comments
Hi Andras,
I will try to catch this.
Regards,
Oleg.
I compare 2 the same databases. SQL Compare 6
1. Using Windows Auth. for both db
SQL Compare aborting, Registering databases
SQL-SRV1.db87-Reading constraints,
Unable to cast object of type 'System.DBNull' to type 'System.String'
2. Using SQL Server auth. for both db, user sa (!)
SQL Compare aborting, Registering databases
SQL-SRV1.db87-Reading object text,
Object reference not set to an instance of an object. SQL Compare 5
1. Using Windows Auth. for both db
SQL Compare aborting, Registering databases
SQL-SRV1.db87-Reading constraints,
Specified cast is not valid.
2. Using SQL Server auth. for both db, user sa (!)
All ok, dbs compared successfully. (!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!)
Note. Windows user is not an admin on the sql server machine.
Regards,
Oleg. / comments
I compare 2 the same databases.SQL Compare 6
1. Using Windows Auth. for both db
SQL Compare aborting, Registering databases
SQL-SRV1.db87-Reading constraints,
Unable to cast object of type 'System....