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 |
|
gorlanda
Starting Member
5 Posts |
 Posted - 2008-11-24 : 02:42:27
|
| Can somebody help me pls because i can not import Database from SQL 2005 in to SQL 2000 with DTS from sql2000.The error msg is " Unnable to connect to source server for transfer.[SQL-DMO]You must use SQL Server 2005 Management tools to connect to this server. <-- this message appear if i select " Copy objects and data between SQL Server database. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 02:44:44
|
| can you just detach the db from 2005 and attach to sql 2000 or just backup and restore it. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 02:45:39
|
| Ah...i think you need to do it from sql management studio using ssis export import wizard. Also is compatibility level of sql db set to 80? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-25 : 15:10:35
|
quote:
Originally posted by visakh16
can you just detach the db from 2005 and attach to sql 2000 or just backup and restore it.
You can't do this from 2005 to 2000. |
|
|
|
|
|
|
How can i Import/export DB from 2005 in 2000