Connect to 3rd Party SQL server

  • Please help!

    We have a client named 'my client' and they have production database in SQL server.

    Recently, we have agree to bring 'my client' data from their Production database to here in Central Reporting database but 'my client' is a 3rd party and we don't have direct VPN connection to create replication to bring data to the Central Reporting db.

    my Question is: how I can connect to SQL server outside of my network and create replication.

    Secondly, what security issue involve while creating this link btween my Central Reporting db and their Production db?

    Thank you,

  • There are very slow and unsecure ways to perform this, but:

    and we don't have direct VPN connection

    pretty much stops you from a good reliable solution.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply