Post reply

Transfering data from one machine to another

  • September 6, 2003 at 4:14 am

    #81963

    Hello all

    I have a SQL Server 2000 database in a remote host and I want to mave all my data to another remote (virtual) host, where on both machines I do not have direct access.

    Can you advise me what is the best way to make this transition?

    Thank You in advance

    Nick

  • September 6, 2003 at 5:16 am

    #472923

    You could place a backup file on a disk (if it will fit) or on a hard drive and restore it as the destination server. If you will need to restore logins, passwords and users, you might use this page.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

    HTH

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • September 6, 2003 at 8:16 am

    #472925

    If the backup is too big, or if it is just data (not schema) you want to move. You could use DTS (or the Export Wizard) to export each table into a CSV file.

    Steven

  • September 7, 2003 at 3:35 am

    #472937

    I'll also go the DTS route, can also compress CSV files. A slow possibility is to use a public domain stored procedure tot select the data and create SQL insert statement. I use it for setup / configuration data. Easy to twiddle settings later on during fine tunning of the application on site.

  • September 7, 2003 at 3:41 am

    #472938

    Thank you all for the advise. I'll try to find what best fits my needs....

    Nick

  • September 7, 2003 at 4:43 am

    #472940

    If it is a big database, DTS'ing out all the tables makes me cringe. I just purchased an 80gb external USB hard drive from Circuit City for $99. Don't rule that option out 🙂

    Ray Higdon MCSE, MCDBA, CCNA

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • September 7, 2003 at 5:04 am

    #472941

    See there is even a 120GB external drive

  • September 8, 2003 at 6:09 am

    #473001

    I guess the only simple way out would be, to take a dump of the database on to any of the external storage devices and send it across and ask respective Admins to Restore the database.

  • September 8, 2003 at 11:30 am

    #473066

    Try http://www.sqlscripter.com to transfer data via T-SQL.

    Regards

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply