使用c#.net在新应用程序中访问或使用旧应用程序的foxpro数据
有一款软件应用程序使用foxpro作为后端。现在这个应用程序需要改变。并希望在.net 中开发相同的新应用程序。但现在数据库将是sql。我不想让用户再次输入所有数据。是否可以在.net的新应用程序中使用foxpro的数据？
编辑：我没有对旧应用程序进行编码。
There is one software application in which foxpro is used as back-end. Now this application is need to change. And want to develop same new application in .net. But now database will be sql. And I don't want to let user make all data entry again. Is this possible to use data of foxpro in new application with .net?
EDIT: I have not coding of old application.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
使用 FoxPro OLE DB 提供程序和 .NET
OleDbConnection（等）类怎么样？或者 ODBC 驱动程序和 OdbcConnection？MSDN 有一个关于 OLE DB 路由的页面。恐怕我不知道这两种方法之间的优缺点是什么——这两种方法肯定都有相关的页面。如果这只是为了吸出一次数据，那么它可能不会太重要 - 你不太可能需要任何高级的东西。
How about using the FoxPro OLE DB provider and the .NET
OleDbConnection(etc) classes? Or an ODBC driver andOdbcConnection?MSDN has a page about the OLE DB route. I'm afraid I don't know what the pros and cons are between the two approaches - there are certainly pages around on both. If this is just for sucking the data out once, it probably won't matter too much - you're not likely to need anything advanced.
据我了解，需要一种方法，通过该方法可以将 Visual FoxPro 数据迁移到 SQL Server 数据库，然后可以直接与新的 .NET 应用程序一起使用，或者作为将数据导入到 SQL Server 数据库的中间阶段。新架构。
如果您不想手动执行此操作，则需要一份 Visual FoxPro 9 和 随之而来的升迁向导。
What is required as far as I understand is a method by which you can migrate the Visual FoxPro data into an SQL Server database, which can then be used with the new .NET application directly, or as an interim stage in getting the data into a new schema.
What you need to do that, if you don't want to do it manually, is a copy of Visual FoxPro 9 and the Upsizing Wizard that comes with it.
如果您有完整版本的 SQL Server，请使用 SSIS，它将为您提供最大的灵活性，将数据从 FoxPro 转换到 SQL Server 中的新表。另外，如有必要，可以轻松重新运行。
如果您拥有 FoxPro 版本（如果您拥有 MSDN 许可证，则应该拥有该版本），则可以使用 Alan B 提到的升迁向导、进行 SQL Pass-Through 调用、CursorAdapter 或远程视图。
否则，您可以使用C#中的OleDB从foxpro获取数据，然后将其写入SQL Server。如果您不打算从新应用程序访问 FoxPro 数据，那么其实并不值得学习。
If you have the full version of SQL Server, use SSIS, it will give you the most flexibility for transforming data from foxpro to the new tables in SQL Server. Plus it is easy to re-run if necessary.
If you have a version of FoxPro, which you should have if you have an MSDN license, you can use the upsizing Wizard that Alan B mentioned, make SQL Pass-Through calls, CursorAdapters, or remote views.
Otherwise you can use OleDB from C# to get the data from foxpro, and then write it to SQL Server. Not really worth learning though if you don't plan on accessing the foxpro data from the new application.