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 |
|
gk_sql
Starting Member
9 Posts |
 Posted - 2006-10-16 : 05:15:09
|
| Hi I have a 30 gb sql server 2005 database. Now i want to migrate the databse to sql server 2000. I tried backup and restore ,Attach and detach --> it is not happening..throwing an error "invalid file format'. DTS is also not working as i tried to copy tables from 2005 to 2000 server.Plz advise.GK |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-16 : 05:16:58
|
You can't downgrade a 2005 database to a 2000 database. BCP, DTS should work.
KH |
 |
|
|
gk_sql
Starting Member
9 Posts |
Posted - 2006-10-16 : 05:49:24
|
| DTS is not working from 2005 and 2000. It is showing an DMO error.we have a lot of sp's and triggers in 2005 that needs to be migrated to 2000. Is there any alternative way other than DTS ? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-16 : 05:52:15
|
| script them out?--------------------keeping it simple... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-16 : 06:43:43
|
| SCript the tables and bcp the data.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-16 : 06:59:36
|
| Remember that you'll only be able to directly copy data structures that are compatible with (exist in) SQL Server 2000. This may mean that you have to create and the manually edit scripts based on the 2005 database in order to downgrade. DDL triggers for example can't be ported across.-------Moo. :) |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-16 : 07:05:48
|
| Also things like varchar(max) which some people seem to really like.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-16 : 07:14:42
|
"Also things like varchar(max) which some people seem to really like"Are you against them as a substitute for TEXT - e.g. where normal string handling functions would be useful?(I wasn't meaning "as a substitute for varchar(50) everywhere"  )Kristen |
|
|
|
|
|
|
Database Restore