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 |
tolisss
Starting Member
17 Posts |
Posted - 2006-06-08 : 03:41:32
|
Hi to alli need to move a database from Sql Server 2005 to Sql Server 2000. And the only way i can think to do that is by converting the db to sql script.The Create statements are easy but how can i tell sql server 2005 to create scripts to tranfer the data that tables already contain |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-08 : 04:14:20
|
if you're just moving, why not just export the data along with the objects?--------------------keeping it simple... |
|
|
tolisss
Starting Member
17 Posts |
Posted - 2006-06-08 : 04:41:21
|
but how can i do that ? i think that moving from 2005 to 200 is not supported when i try to connect using 2005 manager to 200 server i get the foloowing (see link)http://dunant.othisis.gr/dump.jpgany ideads? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-08 : 05:25:17
|
use sql microsoft ole db driver for sql server instead of native client--------------------keeping it simple... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-08 : 05:42:03
|
I would bcp out all the tables and bcp them back in again.==========================================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. |
|
|
tolisss
Starting Member
17 Posts |
Posted - 2006-06-08 : 05:49:27
|
quote: Originally posted by jen use sql microsoft ole db driver for sql server instead of native client--------------------keeping it simple...
:( http://dunant.othisis.gr/dump2.jpg |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-08 : 22:49:05
|
is pharmaxis allowed to connect? did you register the sql2000 server on ssms?try to register and connect first to sql2000 to eliminate connection problems--------------------keeping it simple... |
|
|
|
|
|