SQL Server Performance

Replicating data to fox pro

Discussion in 'Performance Tuning for SQL Server Replication' started by Eudes, Jan 15, 2005.

  1. Eudes New Member

    I have a web application that store data into a Sql Server Database. I need that data to replicate to a Fox Pro database running on other server. The replication must be over internet.

    How can i do this safetly?

    I appreciate any help and advise you could give me.

    Thanx
  2. satya Moderator

    From SQL Server 7 and presumably beyond, SQLServer uses LinkedServers for replication.

    When you set up the linked server you will define a username and password that SQL Server will use to access the remote data.

    Once you have defined a linked server you can create queries that access and join data on your server and a linked server. To me the most seamless way to do this is to create views that use your linked server data to simplify the access.

    Other option is to use DTS where you can get the OLEDB FoxPro Driver that comes with Visual FoxPro 7.0. I use that in my DTS package and I can upload files perfectly.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Eudes New Member

    Thanx satya, I want to implement the second option uploading data through an OleDb becuase the Sql Server is on a web Server that I just have access to my database. But, i want to know how safetly goes the data through the OleDb connection?

    Thanx again
  4. satya Moderator

    If the compatible OLEDB driver is selected in SQL server against the Foxpro data, there will not be any issues about data transformation..

    If you're talking about security means it depends how you control the permissions for the users against the database.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. Eudes New Member

    Thanx once again satya


    The security issue is that i have to pass very important data through the oledb connection, and i would like to know if there is any encription in the oledb drivers that keep the information secure.

  6. satya Moderator

Share This Page