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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 13:00:00
|
| Vijay writes "How do I establish a two way online interface between SQL 2000 and Filepro.We are developing one of the modules existing in Filepro to the Microsfot Tech. this is done phase by phase, so we require a two way online interface between SQL 2000 and Filepro." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-17 : 13:04:46
|
Based on some brief research I did on FilePro, I really don't think this is possible, certainly not practical. If FilePro supported ODBC, you could possibly create a linked server to do this, but I can't find anything on FilePro and ODBC.The *best* you can do is to write some kind of import/export bridge that dumps the data into text files. Considering that FilePro has an export option for WordPerfect format...let's just say that's not a viable option either.  IMHO you're much better off either sticking with FilePro only, or dumping it completely and moving everything to SQL Server. You will only experience heartache and aggravation if you try to get both to work together; don't waste your time.EDIT:Actually, I should've mentioned this earlier, but in truth you should learn about SQL Server and design a new system FROM SCRATCH. DO NOT carry over any table designs from FilePro. If you try to migrate it, you'll end up with a poorly performing and horrendous system that cannot take advantage of SQL Server's strengths. Trust me on this, based on every experience I've ever had migrating stuff like this; it might not save time (but won't take longer either), but it WILL save a shitload of frustration.Edited by - robvolk on 06/17/2002 13:09:21 |
 |
|
|
|
|
|
Two way Online Interface with SQL Database from Filepro