[RESOLVED] [sql2005] Dts?

hi i not sure if im reading the right article in http://www.sqldts.com. anyway my concern is how it will be possible to cascade update/delete row from two different database. the idea was like a primary and foreign key were both table are members of single db.

You want to perform an update/delete in db1 when an update/delete occurs in db2? Sounds like you want replication rather than DTS.

hi mendhak, yes you got the idea correct. it should be replication not dts? any idea how it will be implemented? i know there are lot of reference out there but i would prefer if you would recommend a site.

thanks.

I think what you need is transactional replication. With transactional replications, an update in one database gets pushed across to another database.

You wanted a link and the first result in the search engines is a how to, with a description of how it works.
http://www.databasejournal.com/featu...le.php/1438201

thanks mend. so i was trying to understand the replication technique and finally moving on to the actual hands-on... i was so excited that i missed the CONDITIONS to avail the feature and since im using EXPRESS edition... i fall in the dead end... argh!