Hello

I have 2 identical databases and I want to export all data from Database A to Database B. And remove the data from database A after the export. Thanks for any help.

I would use BACKUP and RESTORE to do the move and I would use a script to
create an Empty version of Database A.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Lontae Jones" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for any help.