Solved

Join sql data different servers

Posted on 2011-09-09
3
342 Views
Last Modified: 2012-05-12
I need to report on sales data coming from two point of sale systems. Both systems dump all their sales data into sql server but into two separate instances/ servers. One goes to sql 2008 and 1 to sql 2005. I have created views on both systems to see what sales info I am interested in. Is it possible to join this data and report it on one report??

Thanks

Noreen
0
Comment
Question by:jmauel
3 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 250 total points
ID: 36510387
Yes.  As long as your servers are linked, and the two datasets are joinable, you can pull from both of them, into a single report.  

If you want to provide more specific detail on the two datasets, I can give a better example.
0
 
LVL 21

Assisted Solution

by:JestersGrind
JestersGrind earned 250 total points
ID: 36510430
Hi Noreen,

You need to create a linked server on the SQL 2008 server that points to the SQL 2005 server.  Here are some instructions.

http://msdn.microsoft.com/en-us/library/ff772782.aspx

Then you should be able to query across servers through OPENQUERY..  

http://msdn.microsoft.com/en-us/library/ms188427.aspx

Greg

0
 

Author Comment

by:jmauel
ID: 36521697
Thanks for both the comments. I have created the linked server and now I will see if I can query across it.

Thanks
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to import SQL 2000 database to SQL 2014 5 159
Analysis of table use 7 63
Help with simplifying SQL 6 54
Database maintenance 36 108
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question