Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

Join sql data different servers

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
jmauel
Asked:
jmauel
2 Solutions
 
dbaSQLCommented:
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
 
JestersGrindCommented:
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
 
jmauelAuthor Commented:
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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now