Add data from a database to other

[marcial4]

Hello, I have two databases (1 in production, 1 in QA)and I need to put part of all data from the production database to the QA database. I just want the data, because I don't how different the databases are... what can I do?

 

[topher0303]

Look at using DTS.

 

[MeanGreen]

You could use a SELECT INTO statement to create your table with the columns. Example:

Select top 10000 * into MyQATable from MYProductionTable
order by MyDateColumn

Hope this helps.

 

[marcial4]

Thank you for your answers, I though in a DTS too, but I don't know what tasks and components I need to use inside my DTS to do my job...

 

[Kurniadi]

Hi marcial4...

You can use SQL Server Enterprise Manager - Tools - DTS - Import or Export Data.

Thank's.

Kurniadi