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 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. 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
Archived
This topic is now archived and is closed to further replies.