none
copy database tables

    Question

  • Hi!

    Can someone tell me how I can copy my database which is made with SQLExpress or the tables to another SQL server. The servers could be SQL server 2000 and SQLExpress.

    Thanks!

     

    Tuesday, April 18, 2006 10:10 AM

Answers

  • SQL Server Express --> SQL Server Express (or any other 2005er edition), just detach the mdf file (if possible) and copy it to the destination location, then attach the orginal one to the server again, and attach the copy to the remote server -done. If you have no maintainance window to do so, make a backup and a restore on the other server (could take a bit longer but keeps your database online during the whole time)

    SQL Server Express --> downgade versions: Create scripts of your objects and data. Make sure that the scripts are compatible with the versions you want to deploy it to.

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Tuesday, April 18, 2006 10:30 AM
  • Doing a copy from SQL Server Express to SQL Server Express should work fine, which error message are you getting ?

    If you have a SQL Server 2000 Dev/Std/Ent you can use the DTS Wizard to copy the database from SQl Server Express to SQL 2000 (Import).

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Tuesday, April 18, 2006 6:07 PM

All replies

  • SQL Server Express --> SQL Server Express (or any other 2005er edition), just detach the mdf file (if possible) and copy it to the destination location, then attach the orginal one to the server again, and attach the copy to the remote server -done. If you have no maintainance window to do so, make a backup and a restore on the other server (could take a bit longer but keeps your database online during the whole time)

    SQL Server Express --> downgade versions: Create scripts of your objects and data. Make sure that the scripts are compatible with the versions you want to deploy it to.

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Tuesday, April 18, 2006 10:30 AM
  • At first I made backup file of my SQLExpress database and and copy it to another PC witch have SQLExpress also, but I didn't work.

    Then I tryed the script and it did work. Now I have to test this also to SQL Server 2000.

    The question, is what did I do wrong with the backup?

     

    Tuesday, April 18, 2006 1:20 PM
  • Doing a copy from SQL Server Express to SQL Server Express should work fine, which error message are you getting ?

    If you have a SQL Server 2000 Dev/Std/Ent you can use the DTS Wizard to copy the database from SQl Server Express to SQL 2000 (Import).

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Tuesday, April 18, 2006 6:07 PM