Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
josh2009
Yak Posting Veteran
81 Posts |
 Posted - 2009-06-12 : 09:44:23
|
| If I were to use the ff statement -INSERT INTO JB_Inventory ([SS_Item_Location_ID],[SS_Item_ID],[SSRoomID],[On_Hand],[Item],[Room_Name],[Catalog_Number])SELECT SS_Item_Location_ID,SS_Item_ID, SSRoomID,On_Hand,Item,Room_Name,Catalog_NumberFROM Apollo_Test.dbo.JB_InventoryWHERE SSRoomID = 7Apollo_Test being the database name and I need to copy selected records from test database to prod database from a PC workstation to a laptop, can I use the ip address and qualify the FROM clause in my insert statement? INSERT INTO JB_Inventory (...FROM 172.xx.xx.xxx.Apollo_Test.dbo.JB_InventoryWHERE SSRoomID = 7 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-12 : 12:05:08
|
No.Search for linked server please.That may be your solution.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-06-14 : 11:56:55
|
| Are they in same network? You can export/Import wizard for it. |
|
|
|
josh2009
Yak Posting Veteran
81 Posts |
Posted - 2009-06-15 : 09:12:12
|
| Yes they are in the same server and there will be times that they would be in the same database but at times would be between two databases within the same server. |
|
|
|
|
|
|
|
|
Copying Data From PC to Laptop