Results 1 to 3 of 3

Thread: Ms Sql

  1. #1

    Ms Sql

    Does anyone know how to move MsSQL database to another MsSQL (if this is easier)

    or MySQL or Access?

  2. #2
    From MSSQL to MSSQL the easiest way is to backup (vie Entreprise manager) and restore to the other server (via entreprise manager).

    You cna also do it using a DTS, this will be a one-step process, but I had trouble with this in the past, I prefer backup&restore.

  3. #3
    Join Date
    Dec 2003
    Location
    UK
    Posts
    652
    A quicker solution is to detach the database, make a copy of the physical files, then attach it on the new server.

    Look in BOL for sp_detach & sp_attach.

    If you need a copy on both servers, you can simply re-attach on the 1st server as well.

    If you want to put the data into MySQL, then assuming you're using fairly standard data types, why not use linked servers or make a DTS using an ODBC to MySQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •