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 |
|
mayerl
Yak Posting Veteran
95 Posts |
 Posted - 2010-04-22 : 08:00:08
|
| Morning,I am pretty sure I know the answer but I told my boss I would ask the question. He has a blank database he wants to use for forecasting, no he's not buying a tool he's having an engineer write it, then he has a production database with all the stored procs, views and functions that production databases have. Now the tricky part he wants what AS400 used to do and I'm not sure if it does since I know little about it. He wants a "covering" database known in AS400 as a "logical" one. This would look at both databases and union them for lack of a better word and then you would write queries off of the covering/logical database. I told him there was no such animal and the only way to get what he wanted was to write queries referencing each database every time you wanted to write a query.Was I right? Or is there some kind of way to do what he's asking?ThanksLaura |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-22 : 08:15:33
|
| Well, you could write views that 'union' the two databases and query off of those. There's no automated way that I know of.--Gail ShawSQL Server MVP |
 |
|
|
mayerl
Yak Posting Veteran
95 Posts |
Posted - 2010-04-22 : 09:03:25
|
| That's what I thought. Thanks for the validation Gail.Laura |
|
|
|
|
|
|
Possible to create "covering" database?