Prompting to Create New Database with SQL Server 2000 Target

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Prompting to Create New Database with SQL Server 2000 Target

Postby howarthcd » Tue Jan 03, 2012 2:31 pm

When performing a comparison where the target is an existing database attached to a SQL Server 2000 instance then I am prompted to create a new database when clicking 'Compare Now' on the 'New Project' window even though the target database exists.

The project options are set to 'Red-Gate Defaults' and the 'Decrypt encrypted objects on 2005 and 2008 databases.' option is not selected.

After running SQL Profiler against the SQL Server 2000 instance, the following queries are executed against the instance by SQL Compare:

Code: Select all
exec sp_executesql N'SELECT name from sys.databases where name = @dbName', N'@dbName nvarchar(8)', @dbName = N'MyDB'


Code: Select all
SELECT df.name as logical_name, df.physical_name as file_path, df.type_desc as file_type, f.name as file_group  FROM sys.database_files df
LEFT OUTER JOIN sys.filegroups f ON f.data_space_id = df.data_space_id;


These queries obviously fail when executed against SQL Server 2000.

SQL Compare version 10.0.0.143

The product documentation implies that it should be possible to use an existing SQL Server 2000 database as a target.

http://www.red-gate.com/supportcenter/Content/SQL_Compare/help/10.0/sc_Comparing_Diff_Versions

"If you are updating a SQL Server 2000 database..."

Chris
howarthcd
 
Posts: 50
Joined: Wed May 16, 2007 10:30 am

Postby howarthcd » Tue Jan 03, 2012 2:33 pm

...actually looks like this is a repeat of the following post:

http://www.red-gate.com/MessageBoard/vi ... hp?t=14478

The solution presented resolves the issue that I'm experiencing.

Chris
howarthcd
 
Posts: 50
Joined: Wed May 16, 2007 10:30 am

Postby peter.peart » Thu Jan 05, 2012 3:55 pm

Thanks for your post. I'm glad the patch resolved your issue.
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest