Making Data Available over the Internet / Pulling Data from a Remote Server

• hermandm

  SSC Rookie

  Points: 31

  More actions

  August 16, 2011 at 12:13 am

  #241774

  What is the best way to setup the following scenario:

  I have a SQL 2008 database with a Customer and a Job table in domain A.

  These tables need to be made partially available on a remote site (SQL Server 2008, on a different geographical location, in a different domain B).

  At the same time, I need to "pull" time registration data from the remote domain B back to domain A.

  Important: domain A will not accept incoming connections! Domain A will push/pull data to/from domain B.

  What should I use:

  - setup web services in domain B?

  - setup replication?

  - use linked server?

  - other ... ?

  Many thanks for your advice.

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  August 16, 2011 at 2:18 am

  #1368970

  Is there cross domain authentication possible between A and B ie do they trust each other ?

  Replication with a UI front seems to be good fit for what your trying to achieve.

  If your trying to do reporting on a BI scale then there are more considerations such as should you have a ETL process.

  Do you need a full fledged reporting solution like SSRS or microstrategy etc.

  In a very basic sense ; replication with the web UI should do fine.

  Jayanth Kurup[/url]

• hermandm

  SSC Rookie

  Points: 31

  More actions

  August 16, 2011 at 3:22 am

  #1368984

  Thanks for your input.

  I can't promise the trust relationship between both domains.

• jasonmorris

  SSCrazy

  Points: 2492

  More actions

  August 23, 2011 at 6:40 am

  #1371941

  I've used SSIS to create text files and then SFTP them to the destination and restore if there is no chance of any connection between the domains / networks. Or alternatively set up a secure VPN connection and then use a linked server.