Converting SQL 2005 to SQL2000

Hot Topic

FindWindow
Autoload Application on Windows Startup in VB .NET 2005
Windows Forms Problem
VS 2005 and Visual SourceSafe 6
Replacing Text?
Loading Crystal Reports Report, How To Stop Prompt Enter Login ID And Password, This Never Happen Before
Retrieving data from an excel file?
Visual Studio 2005 Compiler Error
Newbie Database Question
custom enumerator, com interop, and vb6 client

Visual Basic

running apps (shell command)
Detect if a file sitting on a network drive opened by another user
Add Item to ListBox from other form?
Best practices: Skipped picturebox control; using the form.backgroundpicture property?
Using Interop to call COM .DLL
How do you download iconbuffet_studio.zip from Microsoft Registration Benefits Portal?
setup project can not build
Using sender as a case in Select Case Statement
combining integers
MDI forms

Converting SQL 2005 to SQL2000

I have a client that asked me to write a .Net app for them using VB2005 and SQL2005.  I started the project and now they have learned that their IT shop will not support SQL2005 at this point and we need to move it to SQL2000.  How can I get the database files and stored procs over to 2000   Is it as easy as doing a backup in 2005 and restore under 2000  
Thanks...




Answer this question

Converting SQL 2005 to SQL2000

  • berwiki

    Hi,

    Yup you could install both on the same machine. That's currently my setup.

     

    cheers,

    Paul June A. Domag



  • Chavez

    Using DTS is a great idea.  I will give it a try.  Many thanks!

  • orchidea

    Hi,

    Still haven't tried backup and restore. But manually you could generate scripts in your SQL2005 the execute it in SQL2000. Or you could try using DTS to move it to 2000...

     

     

    cheers,

    Paul June A. Domag



  • venki99

    One last question.  Can I have SQL2005 and SQL2000 on the same machine, or can I have only one installed at a time

  • Converting SQL 2005 to SQL2000
Answer this question