help_lucky Posted June 2, 2010 Share Posted June 2, 2010 I don't know how to copy table data from one server -> database -> table TO other sever -> database -> table. If it is with in the same server and different databases, i have used the following SELECT * INTO DB1..TBL1 FROM DB2..TBL1 (to copy with table structure and data) INSERT INTO DB1..TBL1(F1, F2) SELECT F1, F2 FROM DB2..TBL1 (copy only data) Now my question is copy the data from SERVER1 --> DB1--> TBL1 to SERVER2 --> DB2 -->TBL2 Quote Link to comment https://forums.phpfreaks.com/topic/203608-copy-data-from-one-sql-server-database-table-to-the-other/ Share on other sites More sharing options...
trq Posted June 2, 2010 Share Posted June 2, 2010 Does this need to be done programatically? Its easy enough to do through enterprise manager otherwise. Quote Link to comment https://forums.phpfreaks.com/topic/203608-copy-data-from-one-sql-server-database-table-to-the-other/#findComment-1066526 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.