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 Administrator1) 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