sql transfer data between databases tsql [duplicat

问题:

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?

回答1:

Assuming MS SQL

bcp Utility

OR

SQL Server Import and Export Wizard

回答2:

In addition to alex's choices you can use linked servers or SQL Data Compare by Redgate.