In my job i connect to a number of SQL servers and databases. I can access and query these databases using Linked servers.
I now have a requirement to connect to a SQL server database that is totally ‘offsite’ and I have no easy way to connect to it. I would usually use SSIS or Linked servers to bring data into our data warehouse but these don’t seem an option at the moment.
Of note; I would be looking to load around 1 gb per day of data into our local data warehouse. In this example I’m using an sql 2008 r2 and would be looking to connect to a sql 2008 r2 database
Can this forum advise on what I should be looking to do? I hoping there are some good articles already out there ;-) or that someone can help with key words or general advice on what I should be looking to do.
Due to our set-up I don’t have any dba’s that I can turn to in this instance so any help would be great!