DTS Import

I have a development database and a live database. I want to do a DTS
export from the live box to the dev box to sync the databases up. The
problem is that the development database has tables, stored procedures
associated to applications that aren't live yet because they are still
be tested or aren't done being programmed. If I do the import will
these tables get deleted or will they remain untouched?
Thanks in advance
Hi
Usually you would re-sync the data by scripting the changes from the base
version or (more prefereble) scripting the objects and keeping them in
version control, you can then use an upgrade script on the current version
to bring it into line with the development system.
Tools that may do this include SQL Compare from Red Gate www.red-gate.com
DBGhost www.innovartis.co.uk/Home.aspx and possibly Quest Central for SQL
Server
http://www.quest.com/quest_central/sql_server/freeware/
John
<anthony@.alocovare.com> wrote in message
news:1103136787.823604.21180@.z14g2000cwz.googlegro ups.com...
>I have a development database and a live database. I want to do a DTS
> export from the live box to the dev box to sync the databases up. The
> problem is that the development database has tables, stored procedures
> associated to applications that aren't live yet because they are still
> be tested or aren't done being programmed. If I do the import will
> these tables get deleted or will they remain untouched?
> Thanks in advance
>