SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 create all database from sql script
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tolisss
Starting Member

17 Posts

Posted - 06/08/2006 :  03:41:32  Show Profile
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
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 06/08/2006 :  04:14:20  Show Profile  Send jen a Yahoo! Message
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 - 06/08/2006 :  04:41:21  Show Profile
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
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 06/08/2006 :  05:25:17  Show Profile  Send jen a Yahoo! Message
use sql microsoft ole db driver for sql server instead of native client

--------------------
keeping it simple...

Edited by - jen on 06/08/2006 05:26:04
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 06/08/2006 :  05:42:03  Show Profile  Visit nr's Homepage
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 - 06/08/2006 :  05:49:27  Show Profile
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
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 06/08/2006 :  22:49:05  Show Profile  Send jen a Yahoo! Message
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000