Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    India
    Posts
    7

    Unanswered: copying a DB from one SQL Server to another SQL server which are not in the same LAN

    Hello All,
    I am new to SQL Server.

    I want to copy a Database from my SQL server to another SQL server ,which are not connected in same LAN. The destination SQL server also has the same DB ,Table structures.

    Can you suggest me any idea of doing this.

    I would appriciate your fastest suggestion.

    Thanks!!.

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Backup Database
    Copy
    Paste
    Restore Database
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Dec 2003
    Location
    India
    Posts
    7
    Originally posted by Enigma
    Backup Database
    Copy
    Paste
    Restore Database
    Hi Enigma,
    Thanks for your reply.

    If I am not wrong ,the DBBackup will copy all the Tables in the DB.

    Is it possible to take a backup of few tables from a DB.(This is what needed, sorry for not giving full information on my first question).

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Yup
    1st server... script tables ... bcp out ...

    2nd server ... run script ... bcp in
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Feb 2004
    Posts
    1

    Please give some Examples using VB for the above

    Originally posted by Enigma
    Yup
    1st server... script tables ... bcp out ...

    2nd server ... run script ... bcp in
    Hi,
    Please give some Examples using VB for the above.
    thanx in advance. Looking forward for your reply.

    Premnath

Posting Permissions

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