0

I have a third party Sql Server data, which I need to use as a data source for my custom database, without duplicating data. One thing, which comes to mind is to create a View in my custom database, which would reference one or more tables from this third party database. Is this possible with Sql Server 2014?

Eugene Goldberg
  • 12,610
  • 19
  • 85
  • 154

2 Answers2

2

Yes, as long as they're on the same server, TSQL: Create a view that accesses multiple databases . If they're on different servers, then you'd have to create a linked server, which I wouldn't suggest unless you're aware of the pitfalls.

Community
  • 1
  • 1
Bruce Dunwiddie
  • 2,798
  • 1
  • 14
  • 19
1

Yes very much it is possible but you need to fully qualify the table name like

create view testview
as
select * from db_name.schema_name.table_name
Rahul
  • 73,987
  • 13
  • 62
  • 116