Data Compare 10.2 issue with SQL Server 2000 databases

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Data Compare 10.2 issue with SQL Server 2000 databases

Postby Andrew Hodge » Tue Jun 12, 2012 10:51 am

Just upgraded to 10.2 of data compare and getting an error when trying to compare two SQL Server 2000 databases.

Getting an error straight away when hitting compare stating is_system_named. Any suggestions

http://www.ahah.org.uk/forumposts/sqldatacompare102error.jpg
Andrew Hodge
 
Posts: 90
Joined: Thu Jul 19, 2007 8:34 am
Location: Kent, UK

Postby Chris Auckland » Tue Jun 12, 2012 2:51 pm

Sorry you're hitting this. It's a known issue and we should be releasing a fix for it in the next update. Our internal tracking code for this is SDC-1388.

I'm not sure exactly when the update will go out, but it should be in the next few weeks. I can send you a link to a previous version if you can't wait for the fix.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby Andrew Hodge » Tue Jun 12, 2012 2:53 pm

No worries, glad you guys are still supporting 2000. Trying to get rid of our 2000 instances but 1 or 2 just wont die.

Please can I have a link to the previous version.

Many Thanks
Andrew Hodge
 
Posts: 90
Joined: Thu Jul 19, 2007 8:34 am
Location: Kent, UK

Postby chrishimsworth » Tue Jun 19, 2012 9:55 am

Hi Chris,

I have also run into the same problem when comparing against a SQL 2000 database.

Would you be able to send me the link to the previous version and also is there an eta for update?

Regards
chrishimsworth
 
Posts: 3
Joined: Tue Jun 19, 2012 9:51 am

Postby SJR » Wed Jun 20, 2012 2:22 pm

I am also getting this error please include me in the when a patch is released.
SJR
 
Posts: 1
Joined: Wed Jun 20, 2012 2:18 pm

Postby Andrew Hodge » Wed Aug 08, 2012 9:48 am

Just to update this thread v10.2.0.885 released on August 6th appears to have resolved this issue
Andrew Hodge
 
Posts: 90
Joined: Thu Jul 19, 2007 8:34 am
Location: Kent, UK

Postby bjschip » Wed Sep 12, 2012 7:21 pm

I was still getting this error with v10.2.0.885

I went back to v10.1.0.229 and have not seen the issue since.
bjschip
 
Posts: 1
Joined: Wed Sep 12, 2012 7:17 pm

Some more details to help fixing this

Postby glaivier » Thu Sep 27, 2012 1:33 pm

I just encountered this problem with a fresh install of the latest version. I was trying to compare a backup file from SQL Server 2000 with a live database. This generated the described error, but interestingly when I restored this database on the same server and compared there was no such problem. This might be suitable for some people encountering this problem, and suggests that there might be variation between the backup handling and live database handling (perhaps the "fix" can be copied between these sections of the program?).
glaivier
 
Posts: 1
Joined: Thu Sep 27, 2012 1:25 pm
Location: London


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests