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 |
|
ereader
Yak Posting Veteran
50 Posts |
 Posted - 2003-03-24 : 23:41:20
|
| Hi! allWe have data on the production server and we want to extract some information and put it into a new database Means to maintain the historical production data into a new database using customized queries which is the best possible way to to extract the data according to our specification 1)should we have to write a script 2)should we develop a application for that who reads data query the database and populate into another database |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-24 : 23:44:44
|
| What about DTS ?Damian |
 |
|
|
ereader
Yak Posting Veteran
50 Posts |
Posted - 2003-03-25 : 00:21:13
|
quote:
What about DTS ?Damian
DTS is ok but we have to generate lots of query by which we want to pick the latest details of the production database put it into a new database(query remains the same for specified retrieval) to generate statistics report from the new databse, some query may require after every hour or some may need twice a dayneed more information?Thanks |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-25 : 00:50:00
|
| What about Replication ?Damian |
|
|
|
ereader
Yak Posting Veteran
50 Posts |
Posted - 2003-03-25 : 01:01:13
|
quote:
What about Replication ?Damian
Thanks dameinbut my requirement is bit different, i give u the detail requirement in short while |
|
|
|
|
|
|
Database to database