Copying / Merging a Database

Hello
This seems very simple idea to do, but just dont know how.
I have to databases QLFL and QLFD (our naming convention is 3 letters to
symbolise application/db, and the last to symbol its use L=Live,
D=Development)
I want to import ALL records from live into development, ie copy the data,
but i tried the import wizard, and it fails as the tables all exist in
Development, i know that, i just need the data copying. would prefer a
completely automated way, as this database does have 1190 tables in it.
_________________________
Adam Simmonds
Systems Administrator
1) go through the import wizard, and save as ssis package but to not
execute.
2) script a drop statement for every table, save as file
3) edit the ssis package and add in a tsql execute step before the inserts
and paste in the drop script
4) save and execute
Note it could be just as easy to create a new database, execute the import
package into that, then script and transfer all the other objects in the
original database.
I would also recommend ApexSQL's Diff product, which can sync data as well
as other database objects, and can be automated as you require.
TheSQLGuru
President
Indicium Resources, Inc.
"Adam Simmonds (SimAda00)" <AdamSimmondsSimAda00@.discussions.microsoft.com>
wrote in message news:E6BCBA3C-2876-44C3-A890-BCEA81E27413@.microsoft.com...
> Hello
> This seems very simple idea to do, but just dont know how.
> I have to databases QLFL and QLFD (our naming convention is 3 letters to
> symbolise application/db, and the last to symbol its use L=Live,
> D=Development)
> I want to import ALL records from live into development, ie copy the data,
> but i tried the import wizard, and it fails as the tables all exist in
> Development, i know that, i just need the data copying. would prefer a
> completely automated way, as this database does have 1190 tables in it.
> --
> _________________________
> Adam Simmonds
> Systems Administrator