Programming Help

Web Development



What's Here?

  • Members: 150,420
  • Replies: 508,489
  • Topics: 80,160
  • Snippets: 2,669
  • Tutorials: 709
  • Total Online: 1,102
  • Members: 97
  • Guests: 1,005

Welcome to Dream.In.Code
Become an Expert!

Join 150,420 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,102 people online right now. Registration is fast and FREE... Join Now!




restore db from MS SQL2005 to MS SQL 2000

 
 Reply to this topicStart new topic

restore db from MS SQL2005 to MS SQL 2000, Backwards compatablilty should be left for video games
corliss
2 Apr, 2008 - 09:41 AM
Post #1

D.I.C Head
Group Icon

Joined: 25 Oct, 2006
Posts: 128



Thanked: 1 times
Dream Kudos: 50
My Contributions
Hi all.
I am trying to restore a database made in MS SQL 2005 to a 2000 MS SQL server.
CODE

sp_dbcmptlevl database, 80

After running this command I have created a backup from the SQL 2005 server.
When the back up finished I tryed to restore the DB to the SQL 2000 server.
I get an error of 3205.
I have researched the error and found what it means.
My question is can I restore a db made in 2005 to a db server running SQL 2000?

Please Help fellow dic's

This post has been edited by corliss: 2 Apr, 2008 - 09:44 AM
User is online!Profile CardPM
+Quote Post

Martyr2
RE: Restore Db From MS SQL2005 To MS SQL 2000
2 Apr, 2008 - 10:32 AM
Post #2

Programming Theoretician
Group Icon

Joined: 18 Apr, 2007
Posts: 5,660



Thanked: 314 times
Expert In: C/C++, Java, VB, VB.NET, C#, PHP, Web Development, HTML & CSS, Javascript

My Contributions
There have been structural changes done to SQL 2005 that makes is very very very hard to restore a database from 2005 back to 2000 directly. 2000 just has trouble reading it.

You can do it using SSIS packages supposedly, or you can have 2005 export it as pure sql script or something similar which can then be run and executed on 2000.

You could also try an export to a file like CSV and then import through 2000 (that is if the database isn't too big).

But your options in general are limited. smile.gif
User is offlineProfile CardPM
+Quote Post

baavgai
RE: Restore Db From MS SQL2005 To MS SQL 2000
2 Apr, 2008 - 10:44 AM
Post #3

Dreaming Coder
Group Icon

Joined: 16 Oct, 2007
Posts: 2,291



Thanked: 136 times
Dream Kudos: 475
Expert In: C, C++, Java, C#, ASP.NET, PHP, Perl, Python, Oracle, SQL Server, MySql, HTML, JavaScript, Lua, Cheese

My Contributions
What Martyr2 said.

MS tools may help. In the 2005 SQL Server Manager Studio is an "Import and Export Wizard" that uses OLE DB connects and can even move stuff to and from Oracle; I'd start there.

If all tools fail, here's the more manual method: First create the structure for the tables in the destination database server. Use a SQL Server command line tool called bcp to export data from the source server into flat files. Yes, you have to do it for each table. In the destination database use the "BULK INSERT" command to read those files you generated into their repspective tables.

Hope this helps.
User is online!Profile CardPM
+Quote Post

corliss
RE: Restore Db From MS SQL2005 To MS SQL 2000
2 Apr, 2008 - 11:02 AM
Post #4

D.I.C Head
Group Icon

Joined: 25 Oct, 2006
Posts: 128



Thanked: 1 times
Dream Kudos: 50
My Contributions
Thanks for the help guys.
It will take me some time to work this out.
Cheers,
and THx again.
User is online!Profile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/9/09 08:22PM
Invision Power Board v2.1.7 © 2009  IPS, Inc.
Licensed to: MediaGroup1

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month