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 |
|
Juls
Yak Posting Veteran
51 Posts |
 Posted - 2003-11-06 : 13:09:45
|
| Hi,I was wondering: is there a tool out there that will make the process of moving data to another (reporting) database from production a much easier process.I currently use a number of DTS packages with stored procedures, temp tables and schedule all that into Job that runs everynight that compare a timestamp field on a record from production DB to DataMart (database used for reporting purpose) to update any data that changed.I also have to manually go through a tedious process to incorporate new fields that were added to production to be a part of DTS/Job mess.THERE HAS GOT TO BE AN EASIER WAY!!!!Please help!Thanks,Juls |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-06 : 13:11:35
|
| How about replication? From your description, replication is exactly what you are looking for.Tara |
 |
|
|
Juls
Yak Posting Veteran
51 Posts |
Posted - 2003-11-06 : 13:56:34
|
| Thanks. I think this is it too.Cn you tell whaere is the best place I can look for info and directions on setting up replication? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-06 : 14:00:11
|
| SQL Server Books Online is what I use. I learned replication from my boss and have only needed to check out BOL occassionally. Perhaps other people here have suggestions for replication books.Tara |
|
|
|
|
|
|
Updating DataMart