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 |
|
rauof_thameem
Starting Member
31 Posts |
 Posted - 2007-08-30 : 14:34:53
|
| Hi,I am trying to create a package which will pick the data from one database say (test1), process it and put it in some other database say (test2) in daily basis.Issues i have• In test1 database i can(Insert, Update or Delete).• while picking the data from test1 database, it should pick only those records which has been modified.In test1 database i have created on and updated on field, only with these fields i need to keep track of the changes. Based on this guide me to create the test2 database and how i can achieve the synchronization.Regards,Thameem. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 22:06:58
|
| Why don't use replication? |
 |
|
|
|
|
|
Data Transformation