SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 MSSQL 2000: copying database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

wbb1975
Starting Member

23 Posts

Posted - 10/04/2006 :  06:44:27  Show Profile  Reply with Quote
Hi,

I am using MSSQL 2005 but we have to work in compatibility mode with MSSQL 2000 and also we are only allowed to use 2000-compatible features, now my question:

I need to programmatically copy a database within the same server (including all stored procs, triggers and tables, indices) ...

Can anybody give me a hint what is the best way for reaching this target??

Thanks a lot in advance

Greetings
Stefan

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/04/2006 :  06:54:39  Show Profile  Reply with Quote
If it was me I would work on a SQL2000 database, and Backup + Restore it to SQL2005 for testing.

That's probably no help though!

Kristen
Go to Top of Page

wbb1975
Starting Member

23 Posts

Posted - 10/04/2006 :  06:56:12  Show Profile  Reply with Quote
;-))
Yeah, this works, but I need to start this operation programmatically on MSSQL 2000 developing on MSSQL 2005 ....
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/04/2006 :  07:05:00  Show Profile  Reply with Quote
Migrating a database from SQL2005 to SQL2000 is not very easy (compared to the other direction at least!)

I reckon DTS is your only obvious route.

And you'll need to be maintaining scripts of all the objects so you can can run the scripts against SQL 2000.

Might be easier to just persuade your customers to upgrade to SQL2005 !

We've taken the route of being a late adopter for SQL 2005. All our customers are still on SQL 2000.

Kristen
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29910 Posts

Posted - 10/04/2006 :  07:14:21  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I don't think this forum is made for requesting scripts.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

wbb1975
Starting Member

23 Posts

Posted - 10/04/2006 :  08:33:04  Show Profile  Reply with Quote
Yes sorry, I should have posted it to T-SQL-forum ... ;((
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000