Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wbb1975
Starting Member
23 Posts |
 Posted - 2006-10-04 : 06:44:27
|
| 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 advanceGreetingsStefan |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-04 : 06:54:39
|
| 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 |
 |
|
|
wbb1975
Starting Member
23 Posts |
Posted - 2006-10-04 : 06:56:12
|
| ;-))Yeah, this works, but I need to start this operation programmatically on MSSQL 2000 developing on MSSQL 2005 .... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-04 : 07:05:00
|
| 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 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-04 : 07:14:21
|
| I don't think this forum is made for requesting scripts.Peter LarssonHelsingborg, Sweden |
|
|
|
wbb1975
Starting Member
23 Posts |
Posted - 2006-10-04 : 08:33:04
|
| Yes sorry, I should have posted it to T-SQL-forum ... ;(( |
|
|
|
|
|
|
MSSQL 2000: copying database