Replicating data to fox pro | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replicating data to fox pro

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
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.
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
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.
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.
Check thru these articles for further information on security in SQL server database:
http://www.sql-server-performance.com/vk_sql_security.asp
http://www.databasejournal.com/features/mssql/article.php/2243271 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.
]]>