Activity overview
Latest activity by cook0002
Comparing database to database (SQL2000) an insert against a table with an identity primary key turns IDENTITY_INSERT on before inserting records. Against the backup, it does not, leading to the error when I try and run the generated script against the source database. At least that's the case for me. I can't find where I would explicitly have turned that off, nor can I understand why that would be default behaviour. / comments
Comparing database to database (SQL2000) an insert against a table with an identity primary key turns IDENTITY_INSERT on before inserting records. Against the backup, it does not, leading to the e...
IDENTITY_INSERT
Is there a known issue with comparing data between tables where the primary key is the identity? The generated script failed to cope with this:
Cannot insert explicit value for identity column in ...
I need to reverse the synchronization direction because my destination server is now on the left. If I still synchronize left to right, I will lose all my new data.
As far as I'm concerned, my problem now has an effective workaround.
Many thanks / comments
I need to reverse the synchronization direction because my destination server is now on the left. If I still synchronize left to right, I will lose all my new data.
As far as I'm concerned, my pro...
Just found out you CAN reverse the synchronization direction. Now we're cooking. / comments
Just found out you CAN reverse the synchronization direction. Now we're cooking.
This does indeed remove the problem. I assume, though, that I cannot reverse the direction of the synchronization from right to left, so I'll just have to live with the comparison deleting and creating records rather than updating them. / comments
This does indeed remove the problem. I assume, though, that I cannot reverse the direction of the synchronization from right to left, so I'll just have to live with the comparison deleting and cre...
Yes it is. / comments
Yes it is.
SQL 7 database has no collation set up against the individual columns.
The server settings (sp_helpsort) are:
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 52, nocase_iso
Case-insensitive dictionary sort order for use with several We
stern-European languages including English, French, and German
. Uses the ISO 8859-1 character set.
SQL 2000 database has the following collation set up against the varchar columns:
COLLATE SQL_Latin1_General_CP1_CI_AS
The server settings (sp_helpsort) are:
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data
I believe this means that both databases are case insensitive. / comments
SQL 7 database has no collation set up against the individual columns.
The server settings (sp_helpsort) are:
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
S...
I think I didn't explain myself properly and probably misled you slightly with my last posting.
Neither database treats textual data case sensitively.
Index text in lowercase matches correctly. Index text in uppercase does not match. / comments
I think I didn't explain myself properly and probably misled you slightly with my last posting.
Neither database treats textual data case sensitively.
Index text in lowercase matches correctly. In...
More information - it only seems to affect records with uppercase text
e.g.
A change in a record with primary key cook0002 will result in the record being flagged as different in the two databases.
A change in a record with primary key COOK0002 will result in the record being flagged as new in each database. / comments
More information - it only seems to affect records with uppercase text
e.g.
A change in a record with primary key cook0002 will result in the record being flagged as different in the two databases....
... that's varchar(8) - I now know why there's an option to disable smilies. / comments
... that's varchar(8) - I now know why there's an option to disable smilies.