且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我如何将MS Access数据库应用程序替换为Sql Server应用程序

更新时间:2023-01-01 16:42:38

有趣的是,您从数据集中得到了错误.这些不是数据库特定的对象.

SqlClient类非常接近等效的OleDb类(通常Sql类具有更多功能).

如果您使用搜索和替换进行了转换",则可能是您替换的内容过多(名称中的文字等).

无论如何,我认为***从头开始,仅使用Find查找OleDb类,然后手动检查每次出现的情况,应如何对其进行修改.当您开始执行此操作时,我认为您很快就会为每个类找到一个不错的搜索/替换模式.然后,您可以在每个课程之前进行替换.
It''s funny that you get errors from datasets. These are not database specific objects.

SqlClient classes are very close to equivalent OleDb classes (typically Sql classes have more functionality).

If you did the ''conversion'' with search and replace, it could be that you have been replacing too much (text in the names etc).

Anyhow, I think that it''s best to start from the beginning and just use Find to find the OleDb classes and then manually check each occurrence, how they should be modified. When you start doing this I think you quite quickly find a good search/replace pattern for each class. Then you can do the replacement pre each class.