Solved

Join sql data different servers

Posted on 2011-09-09
3
341 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

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 simplify my SQL statement? 14 55
Strange msg in the SSMS pane 13 58
create insert script based on records in a table 4 24
Email Notifications for SQL 2005 9 36
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 …
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

831 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