Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RichardSteele
Posting Yak Master
160 Posts |
 Posted - 2002-12-18 : 22:06:09
|
| Our website inventory data is stored on a remote shared sql server. We have a local Visual FoxPro free table that has changing inventory levels and would like to publish these changes to the remote shared sql server. I know that the remote shared sql server is not set up for replication. However, we have a local MSDE sql table that could act as the publisher. What's the best way to accomplish our goal of keeping the remote inventory levels in sync with the local VFP table? Thanks in advance. |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-12-19 : 00:42:51
|
| None really. MSDE can't act as the publisher because it's not intended for replication. Te only way to do it would be to export the VFP table to a CSV (or similar) file, send it to the SQL server location and then import it using DTS. This could work, but you have to consider data integrity, security, etc.... |
 |
|
|
RichardSteele
Posting Yak Master
160 Posts |
Posted - 2002-12-19 : 09:21:20
|
| That's interesting. Using SQL Enterprise Manager, I'm able to go down the road of data replication pretty far, setting up a publication, subscription, etc, but I'm not able to acutually get it to work. The subscription shows a "never started" status. Trying to start synchronizing does nothing. However, I'm trying to find my way in the dark so I thought that I simply didn't set it up properly. But now it appears, as you say, that MSDE doesn't allow replication. Could I use the Developers edition to do this? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-19 : 09:26:12
|
| I'm not up on MSDE, but if it supports linked servers, you may be able to set up a linked server to the FoxPro table. Then you can query it as if it were another MSDE table. I don't think it would be a good idea to constantly query the linked FoxPro table, but you can write a simple job that refreshes the MSDE table from it at periodic intervals. IT would give you a poor-man's replication. |
|
|
|
|
|
|
|
|
Replication and remote Shared SQL Server