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 |
|
BartMan
Starting Member
22 Posts |
 Posted - 2004-09-21 : 14:17:48
|
Greetings,I am currently involved with a project which has to take information from multiple databases found accross the network and merge them into a single customizable report. (Examples:)SQL server A------------TestTable1 - 3 fields of data.Data row example: testdataA,testdataB,testdataCSQL Server B------------TestTable1 - 3 fields of data.Data row example: testdataX,testdataY,testdataZThe example of how the report would contain the records?entry 1: testdataA,testdataB,testdataCentry 2: testdataX,testdataY,testdataZNow what would be the best way to do a report which can be customizable of this type? Crystal Reports, XML, ect?Is there a standard way in which this is done?Thanks in advance for any suggestions!  |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-09-21 : 14:34:11
|
| How much data in each table?You've got 2 issues.1. Getting the data2. Presenting the dataI would worry about #1 firstBrett8-) |
 |
|
|
BartMan
Starting Member
22 Posts |
Posted - 2004-09-21 : 16:04:26
|
quote:
Originally posted by X002548
How much data in each table?
Probally about 360 records a day at each time a report would be run for each server. So in this example there would be 2 servers so 720 records. This is just a rough guess, but I think it is pretty close. It gets even higher when more servers get added to the network. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-21 : 23:51:53
|
| you may have one database for reports, include all those tables you mentioned or replicate them from the transactional databases.this will be easier to maintain IMHO and more scalable in terms of reporting |
|
|
|
|
|
|
|
|
Network and Database Design