January 22, 2004 at 12:53 am
I am seeking your advice. Currently, I have been trying to figure out how to integrate two backend SQL 2000 databases running under the same default instance/non clustered environment. One database is hosting my LANDesk environment and runs under the sa/mixed mode. The other database hosts SMS 2003 running in windows authentication mode. Both require the default instance.
I am looking for any assitance including docs or links which could assist me in integrating the two backend databases specified to do central reporting (in whatever way works, most likely Crystal Reports but also HTML).
----------------------------------- a week later -----------------------------
After reading up some more, I may have found a solution for the backend utilizing the Data Transformation Services package option. This will allow me to consolidate the data, move and transfer data into one database. I just am not too sure how central reporting would work.
Any ideas are greatly appreciated!
Alexzander N. Nepomnjashiy
Technical editor for Wrox Press:
"SQL Server 2000 Fast Answers"
Technical editor for Apress:
"Honeypot for Windows"
"SQL Server Yukon Revealed"
January 22, 2004 at 7:37 am
To access different databases in same instance, you just need to use qualified name like databasename.owner.tablename.
For example, select * from db1.dbo.table1 T1 inner join db2.dbo.table2 T2 on T1.id = T2.id
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply