[RESOLVED] [sql2005] Dts?

[jlbantang]

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.

[mendhak]

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

[jlbantang]

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.

[mendhak]

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

[jlbantang]

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!