Single View creation using tables from different data bases
I have a SQL Server database with three different databases say, DB1,DB2,DB3.
DB1 contains tables say: TB1,TB2
DB2 Contains tables say: TB3,TB4
DB3 Contains tables say: TB5,TB6
Now my requirement is, i requirement to create some set of report using TB1,TB2........TB6, hence i need a single view for all the above tables to build dimensional model.
Is there any way that i can bring different tables from different databases into a single view? ( i know virtual table will support partially but this is hard coded SQL script which i don't want)
Need you help on this.