Red Gate forums :: View topic - Prompting to Create New Database with SQL Server 2000 Target
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Prompting to Create New Database with SQL Server 2000 Target

 Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
howarthcd



Joined: 16 May 2007
Posts: 48
PostPosted: Tue Jan 03, 2012 2:31 pm    Post subject: Prompting to Create New Database with SQL Server 2000 Target Reply with quote
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:
exec sp_executesql N'SELECT name from sys.databases where name = @dbName', N'@dbName nvarchar(8)', @dbName = N'MyDB'


Code:
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
Back to top
View user's profile Send private message
howarthcd



Joined: 16 May 2007
Posts: 48
PostPosted: Tue Jan 03, 2012 2:33 pm    Post subject: Reply with quote
...actually looks like this is a repeat of the following post:

http://www.red-gate.com/MessageBoard/viewtopic.php?t=14478

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

Chris
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids
PostPosted: Thu Jan 05, 2012 3:55 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group