srikotesh
asked on
how to create a view for a table which is exist in another database
Hi Experts,
I have a two databases
Test1
Test2
Test1 database have table called items
I want this table data in Test2 database
I want to create a view for this table and i have to access the data via view in Test2 database;
Can some one suggest me how to do a view creation
how to get the data from Test1 database items table to Test2 database xxx view
please find the table data in the attachment.
test.PNG
I have a two databases
Test1
Test2
Test1 database have table called items
I want this table data in Test2 database
I want to create a view for this table and i have to access the data via view in Test2 database;
Can some one suggest me how to do a view creation
how to get the data from Test1 database items table to Test2 database xxx view
please find the table data in the attachment.
test.PNG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
http://stackoverflow.com/questions/10694601/creating-view-across-different-databases