Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Join sql data different servers

Posted on 2011-09-09
3
Medium Priority
?
347 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 1000 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 1000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

916 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