Database Change Management
Database Change Management
Home | Profile | Register | Active Topics | Active Polls | Members | Private Messages | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 DB Ghost Support Forum
 Sync SQL2005 -> SQL2000 Database
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  


1 Posts

Posted - 02/06/2006 :  09:09:09  Show Profile Send _formula a Private Message  Reply with Quote
I've been looking for an easy way to sync the schema of a SQL2005 database with a SQL2000 database for backwards compatibility. DBGhost seems to support this feature, but fails with errors such as this...

- Cannot add user 'sys' as no login exists.
- Cannot add user 'INFORMATION_SCHEMA' as no login exists
- Cannot add table dbo.sysdiagrams
- Line 9: Incorrect syntax near ')'.
- Cannot add view dbo.account_swipes
- Line 3: Incorrect syntax near '('.
- Error adding stored procedure dbo.sp_upgradediagrams
- Line 16: Incorrect syntax near 'max'.
- 'DATABASE_PRINCIPAL_ID' is not a recognized function name.

This is going to be my primary use of DBGhost, and I can't purchase this product unless this works 100%. If someone could let me know how to work around these errors, I would appreciate it. Unfortunately this is my last day of the trial...

Google AdSense

Mountain View

Mark Baekdal

88 Posts

Posted - 02/09/2006 :  14:15:17  Show Profile  Visit Mark Baekdal's Homepage Send Mark Baekdal a Private Message  Reply with Quote
can you send me anything so I can re-create this problem and correct it?

Mark Baekdal
You must be logged in to see this link.
You must be logged in to see this link.
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Jump To:
Database Change Management © Copyright 2005 Innovartis Ltd. Go To Top Of Page
Snitz Forums 2000
RSS Feed 1 RSS Feed 2
Powered by ForumCo 2000-2008
TOS - AUP - URA - Privacy Policy
ForumCo Free Blogs and Galleries
Signup for a free forum or Go Banner Free