Results 1 to 4 of 4

Thread: Import Database

  1. #1
    Join Date
    Jul 2006
    Posts
    5

    Unanswered: Import Database

    Hi all,

    I doing some Online projects....
    for that some time i want to import database from online database server(located in Newyork), some time i want to transfer datatabse from one server to another server.
    At this time i was used DTS Import/Export wizard, but i am not able to copy the relatioships of the tables(Primary key,foreign key,defaults,views,storedprocedures,triggers).

    My query is How i downlod a database with exact structure and all data as it as in remote server.

    thanks in advanse

  2. #2
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    can't u use Backup & restore

    Cheers....

    baburajv

  3. #3
    Join Date
    Jul 2006
    Posts
    5
    thanks for ur rply,,

    then how can i import online database to local..with databse structure and data.

  4. #4
    Join Date
    Jul 2005
    Location
    New Zealand
    Posts
    61
    You copy the .bak file from the remote server to the local server and then do a restore.

Posting Permissions

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