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 - 2003-12-06 : 14:02:46
|
| I need some help thinking through a sticky syncing problem.My company has a commercial software package Mailorder Manager (MOM) based on a VFP 5.0 database (there is a new version based on VFP 8.0 that we have not upgraded to). We do not have access to MOM’s code.Online, we use an online shared SQL Server 2000 in which we cannot be given admin rights. Thus SQL replication is not possible.We are hoping to have "almost live" inventory levels online based on the inventory levels in our local MOM VFP Inventory table. These local inventory onhand levels change throughout the day as we do retail and mailorder along with web orders.Our local VFP table does not have a time/date stamp. Thus we do not know what records have changed.Can someone point me in the right direction for syncing and automating this process?Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-06 : 14:50:47
|
| Linked servers might be the way to go. However, if you don't have admin rights on the SQL Server then this will be difficult to set up. In essence though, they work like linked tables in MS Access (or external data sources in other programs): SQL Server can query the FoxPro tables directly without importing them first. See Books Online for more on "linked servers".If you can't get linked servers set up, take a look at OPENROWSET, that will allow you to pass an OLE DB connection string and should allow you to query FoxPro directly from SQL Server. |
 |
|
|
RichardSteele
Posting Yak Master
160 Posts |
Posted - 2003-12-06 : 15:02:18
|
| Thanks for the help. Our company doesn't allow outside servers to login to our server. So I guess your idea can't be implimented here. Perhaps I should explore how VFP can connect to a remote SQL server using updateable views. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-06 : 15:35:46
|
| What about copying/FTP'ing the VFP files up to your host's server(s), one that the hosted SQL Server can access? If it's done regularly, you get almost-live access to the VFP data without the host having to log in to anything. |
|
|
|
|
|
|
Syncing Remote SQL with local VFP data