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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 create all database from sql script

Author  Topic 

tolisss
Starting Member

17 Posts

Posted - 2006-06-08 : 03:41:32
Hi to all

i 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...
Go to Top of Page

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.jpg

any ideads?
Go to Top of Page

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...
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

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...
Go to Top of Page
   

- Advertisement -