Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-04 : 08:08:58
|
| Eugene writes "Hello,I have DTS code that transform the data from a database and puts the data in an other 'transformed table'. I would like to know how I can keep the 'transformed data' up to date. (Keeping it up to date when they are inserts, but also when they are UPDATES). I think they must be a way to do this using the timestamp data type, but i have never used it. Is there a way to keep up with updates in my database when using (DTS) (Data transformation procedures). How do I do this ? (using timestamp or any other way.)Thank you.Eugene" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-04 : 08:23:57
|
| Take a look at this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14248The staging table approach is the best, IMHO. It will allow you to do what you want in the easiest fashion. You can even avoid DTS altogether, depending on how your tables are configured (how are they configured anyway?) The timestamp datatype may not work because timestamps are database dependent; a timestamp column in two different tables won't synchronize unless you are copying back and forth.What transformations are you doing anyway? Unless they are extremely elaborate, why not create a view that performs the transformations, and have the queries performed against the view instead of the base table? |
 |
|
|
|
|
|
timestamp and data transformation (DTS)