Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: Copying MSDE database

    I have a MSDE database on a laptop and need to copy it to another machine in order to use Access 2000 to inspect the tables and view the data using an Access project adp file.

    Could someone please tell me how to do this and whether there are any relevant issues/problems.

    thanks

  2. #2
    Join Date
    Feb 2004
    Posts
    1

    MSCE - moving data from one PC to another

    BACKUP and RESTORE work fine. There's just no GUI

    You can do interactive tsql by Navigating to

    C:\Program Files\Microsoft SQL Server\80\Tools\Binn

    THEN type osql -E -r1

    ------------------------------------------------------------------------------
    Handy Instructions

    Type in your tsql commands (BACKUP \RESTORE\Whatever)
    For the TSQL reference, go to
    http://msdn.microsoft.com/library/de...sp_00_519s.asp


    To execute these commands, on a line by itself type "GO"


    to QUIT, on a line by itself type "QUIT"

Posting Permissions

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