Possible Duplicate:
SQL Data Transfer
I have my Dev database, and some times I add some data to tables and I want to upload it to prod. Is there a tool that allows transferring data between 2 databases?
Assuming MS SQL
bcp Utility
OR
SQL Server Import and Export Wizard
In addition to alex's choices you can use linked servers or SQL Data Compare by Redgate.
精彩评论