Hi,
I have two questions:
1) I have the same databases on two different servers. I modified, added and
dropped indexes on one of the databases and I need to transfere only the
index changes to the other database. Is it possible to use Copy Objects
Task? I tried but it affects the tables too.

2) I need to transfer only new rows added from databse A to database B. Is
DTS able to identify only new rows (or the rows that don't exist in database
B) and transfer them to B? I cannot use replication :-(

Any help would be greatly appreciated.
Leila

Personally I would use scripts to transfer any changes.

Can DTS identify new rows? No not unless you tell it what to look for.

You can use linked servers and TSQL statements to identfy the new rows by
matching on key values and likewise with deleted rows etc.

Can you identitfy in the source rows the changes ?

If not then you will need to program the logic

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Leila" <leilas (AT) hotpop (DOT) com> wrote