copying_db_from mssql_server

Results 1 to 2 of 2

Thread: copying_db_from mssql_server

  1. #1
    Join Date
    Dec 1969

    Default copying_db_from mssql_server

    i want to copy db from one sqlserver to another(no conection between them)how am i doing it (copying all the tables of a db)or if you can explain how do i copy one table it will be good to.<BR>what i am doing now is converting to access with the mssql tools export/import db wizard,end then converting it again ,there must be an ezy way !!!!.<BR>hope you will help me,thanks.............again!!!!!

  2. #2
    Join Date
    Dec 1969

    Default RE: copying_db_from mssql_server<BR><BR><BR><BR><BR><BR>Basically, you can do <BR><BR>SELECT xxx FROM localtable<BR>INTO [any table in any database, even an external one]<BR><BR><BR><BR>

Posting Permissions

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