Sql Transfer Data Between Databases Tsql

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

Solution 1:

Assuming MS SQL

bcp Utility

OR

SQL Server Import and Export Wizard

Solution 2:

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