November 24, 2013 at 3:19 pm
Hi
I'm pretty new to how the cloud business all works and wondered if someone could offer some advice on a new project I am looking into.
We have a small Datawarehouse hosted on one of our sql servers within our network that uses Business Objects for reporting. Being a none cloud based server It is relatively straight forward to use local ssis packages to upload daily rawftp feeds and interact with other sql servers using linked server objects within the network. However.... We plan to host a new separate sql database in the cloud. I will need to apply daily updates from our datawarehouse server to the cloud sql tables. Would someone advise on the following?
a.) Could I use something like linked server objects to easily interact between the cloud based sql server and office network sql server to update daily tables using join queries? If so what are the limitations?
b.) Would it be better to extract csv data from network based datawarehouse and install sql management studio on the cloud server to upload the extracts to cloud tables using something like ssis packages?
c.) Any better suggestions?
Long term we will look at moving datawarehouse to the cloud also but this would be too much to do in the initial phase.
Any advice on links or experience apprecitated.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply