This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / Please helpThere are two SQL Servers, A and B. From my workstation, I can access Server A by using MS Access front end. And I can access Server B by using SQL Server Management Studio. How can I copy a table in A to B?
-registereduser(立牌坊);
2008-5-14
{207}
(#4452348@0)
-
Newbie try to answer your question. I did the 2 solutions a bit months ago.solution #1
1. Copy A's instance (.mdf .log after detach from server) to B's path: like: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
2. Attach this instance while open Management tool like B's. So you will see 2 DBs under the same server
3. Use Select Into statement to make copy
solution #2
1. Setup A as linked server at B's environment
2. Use select into statement to make copy (should use full namespace like [server].[dbname].[dbo]....etc
Good luck
-newdriger(P0kerFan);
2008-5-15
{486}
(#4453498@0)
-
Thank you very much. I did not try your solution 1 because I do not know the full path. I even don't know whick computer the Server A is.I did similar to your solution #2. I right click to select the "import" then point to the server A. Since I used my windows account signed in, it automatically allowed. Simple as a piece of cake when you know it.
Thanks a lot.
-registereduser(立牌坊);
2008-5-16
{231}
(#4455200@0)