HomeОбразованиеRelated VideosMore From: TheSkillPedia

Linked Server in SQL Server 2012 to Another SQL Server and Excel File

65 ratings | 32560 views
Creating a Linked Server in SQL Server 2012 to Another SQL Server and Excel File. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. To know about me visit my profile at www.rnsangwan.com. I deliver online training on Business Analysis, Linux, Unix, MySQL, Sybase, SQL Server, Perl, Python, R Data Analysis, Scala etc. We can Create a Linked Server in SQL Server 2012 to Any other RDBMS provided we have the appropriate driver. In this video I have demonstrated Link Server creation in SQL Server 2012 to Another SQL Server and Link Server to an Excel File. Once Linked Server is created, you can issue queries in the same manner as if you are issuing them on a local table in a database. The Concept is similar to "Link Database" in Oracle.
Html code for embedding videos on your blog
Text Comments (10)
All Is Here (10 months ago)
very nice video.... but we find easiest method to create linked server.. https://youtu.be/29Qob0xNiTk
Lisa Li (1 year ago)
HI Sir, do you have a video for link to the database in MS Access? also, any video related how to queries in the same manner as if you are issuing them on a local table in a database after linked other SQL server? Thank you so much! Lisa Li
Niharika jhala (1 year ago)
What is Provider String and where can you find it..?
Mithil Kumar P.A. (1 year ago)
hi Niharika, in the meantime did you understand what is Provider String ??
josé Arce Duval (1 year ago)
please, I need parameters between sql server 2014 and excel 2016... what i have to write in "provider string" T_T
Sibasankar Biswal (1 year ago)
Sir, you have both sql instances on same box so linked server worked fine. if sql instances are on different box in that case you need to create an alias else it wont work.
arch1e1963 (1 year ago)
Hi mate - if they are on a different box then you don't need an Alias you can just put SERVERNAME\INSTANCENAME as the Linked Server name... then query as   SELECT * FROM [SERVERNAME\INSTANCENAME].DATABASE.DBO.TABLE for example
Abhishek Singh (2 years ago)
Thank You sir ... !
Chandan Rai (2 years ago)
it is very easy to understand.nice video. thank you sir.
Alex Mercer (2 years ago)
Appreciate your work Sir. Really a good video. This tutorial helped a lot to understand the concept of link server. Looking for more videos of MSSQL server ..! Good Work..! Keep it up..! :)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.