1. 

   karl lauritzen, Member

   I have data on both servers. Mysql server I control. Ms sql server my vendor controls and I only have read access as remote server I access via ssms and ssrs with a url. I have data from prior vendor on mysql. New vendor data on ms sql is current data being updated daily by users. I cannot add tables on ms sql nor allow any user but me access. Linked sever Avoids me doing ftp download and then import to mysql daily from ms sql server. I read here about linked servers. So do I:

   Install mydbr with connection to mysql Then add linked server to ms sql server. That way no changes to ms sql server required and I can have data from both servers in one report on one installation of mydbr.
2. 

   karl lauritzen, Member

   Ok think I figured it out.

   I have data on 2 servers. Static data on mysql that is local. Data on ms sql server that my vendor controls that changes daily.

   I think if I install ms sql express local. Then install mydbr on it. Then add mysql as a Linked server and add acess to my vendor ms sql server as a linked server.

   Then I can make reports on mydbr using both databases in one report.

   Am I right?

Reply

You must log in to post.