从Access迁移到SSCE [英] Migrating from Access to SSCE

问题描述

我在MS Access中有一个带有数据库的应用程序.我想将其迁移到SSCE.
我已经转换了所有数据库.问题出在数据集上.

我是否需要制作所有新数据集，或者有一种方法可以将现有数据集转换为SSCE数据集?

感谢

Hi,
I have an application with databases in MS Access. I want to migrate that to SSCE.
I have converted all the databases. Problem is with datasets.

Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?

Thanks

推荐答案

为了安全起见，您可能必须创建新的数据集，因为OleDb和SqlServer之间的数据类型不同.没有转换工具.

To be safe, you probably have to create new datasets as the data types between OleDb and SqlServer are different. There is no conversion tool.

同意Dave Kreskowiak，最好重新创建数据集.同样，在执行此操作之前，请检查是否已安装所有正确的PK和FK，并且转换没有松动它们中的任何一个.

Agree with Dave Kreskowiak, better to re-create the datasets. Also before doing it, check that you have all proper PK''s and FK''s in place and the conversion didn''t loose any of them.

这篇关于从Access迁移到SSCE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！