sql transfer data between databases tsql [duplicate]

This question already has answers here开发者_C百科: Closed 11 years ago.

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.