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 data between 2 databases?

Solution

Assuming MS SQL

bcp Utility

SQL Server Import and Export Wizard

Remove Identity from a column in a table
Return 1 if value is 0 without CASE statement
Append string text based on pattern search SQL
How to find Cyrillic font (russian characters)?
Why is my sql statements giving wrong results?
Oracle JSON_OBJECT how to have a missing key
DATENAME and DATEPART in SQL
SQL query to pull all database table structure in one go?
Tree view using SQL Query
Query to find parent record
Best way to check if SYS_REFCURSOR is empty
Counting DISTINCT over multiple columns
Multiple joins giving "The multi-part identifier could not be bound"
What row gets selected when you GROUP BY without aggregate function?
How can I remove backslash escaped characters from a string?
On duplicate key ignore?
How to select the last record of a table in SQL?
How to fix MySQL providing duplicates that do not exist?
SQL WHERE NOT EXISTS (skip duplicates)
Search multiple occurrences of a word in a string
Optimize/Shorten SQL Queries
Enable Query Logging in SQLite 3
Finding employees who are not managers
Updating one column based on the value of another column
Combining and aggregating key/value pairs across different events/rows
Why is my SQL Server ORDER BY slow despite the ordered column being indexed?
Easy way of generating a slug name column from the name column?
Optimizing Laravel 8 for efficient handling of large datasets
find time half hour before "06:00 AM" in sql
SQL - Reply a single record in DB as mulitple records given two INT Fields and all values between the two