将数据从MsAccess迁移到MS SQL

Migration of data from MsAccess to MS SQL
2020-10-17
  •  译文(汉语)
  •  原文(英语)

我在MS Access中有一个要迁移到MS SQL的数据.存储的数据是外语而不是英语.我可以在Access中读取数据,就像我在C:\ Windows \ Fonts中存储的字体一样.

我已经通过MS SQL的内置功能将Access数据库迁移到了MSSQL,但是我无法直接在MS SQL和.Net Web应用程序中读取(以奇怪字符存储的数据)该数据.

有人可以建议我吗?

速聊1:
您确定您的MS SQL使用UTF-8作为其字符集吗?
速聊2:
使用SSIS迁移数据.
速聊3:
SQL Server中的列是什么数据类型-它是NVARCHAR吗?请在"无法阅读"上展开.你有错误吗?怪异的人物?
速聊4:
.McDermaid列类型为nvarchar.而且角色也很奇怪
速聊5:
建议您使用该UNICODE函数检查字段中数据的第一个字符.数据可能正确上传,但是您的客户都无法显示.UNICODE会告诉您该字段中的字符是否确实是正确的unicode字符.
解决过程1

请按照官方MS支持中所述的步骤进行操作:

您需要使用导入向导并在运行时测试列.

解决过程2

您还可以使用Access数据库中的升迁向导.说明在这里:

https://support.office.com/zh-CN/article/Move-Access-data-to-a-SQL-Server-database-by-using-the-Upsizing-Wizard-5d74c0df-c8cd-4867-8d07- e6e759d72924

向导不会移动所有内容:

https://blogs.office.com/2012/02/17/five-common-pitfalls-when-upgrading-access-to-sql-server-2/

编辑:

您可以使用向导创建一个新的sql server db,这样可以自动完成编码和排序规则.

I have a data in MS Access which I want to migrate into MS SQL. Data stored is in foreign language not in english. I can read data in Access as I have stored regarding font in C:\Windows\Fonts.

I have migrated Access database into MSSQL by in built functionality of MS SQL, but I can not read(data stored in wierd character) this data directly in MS SQL and in .Net web application also.

Can any one suggest me please?

Talk1:
Have you made sure that your MS SQL uses UTF-8 as its character set?
Talk2:
use SSIS to migrate the data.
Talk3:
What data type is the column in SQL Server - is it NVARCHAR? Please expand on 'can not read'. Do you get an error? wierd characters?
Talk4:
.McDermaid Column types are nvarchar. and also characters are wierd
Talk5:
I suggest you use the UNICODE function to inspect the first character of the data in the field. It's possible the data uploaded correctly but none of your clients can display it. UNICODE will tell you if the character in the field is indeed the correct unicode character.
Solutions1

Please follow the steps described in official MS support:

You need to use import wizard and test the columns as you go.

Solutions2

You could also use the upsizing wizard within the Access database. The instructions are here:

https://support.office.com/en-us/article/Move-Access-data-to-a-SQL-Server-database-by-using-the-Upsizing-Wizard-5d74c0df-c8cd-4867-8d07-e6e759d72924

The wizards do not move everything though:

https://blogs.office.com/2012/02/17/five-common-pitfalls-when-upgrading-access-to-sql-server-2/

Edit:

You could use the wizards to create a new sql server db, that way the encoding & collation is done automatically.

转载于:https://stackoverflow.com/questions/30837961/migration-of-data-from-msaccess-to-ms-sql

本人是.net程序员,因为英语不行,使用工具翻译,希望对有需要的人有所帮助
如果本文质量不好,还请谅解,毕竟这些操作还是比较费时的,英语较好的可以看原文

留言回复
我们只提供高质量资源,素材,源码,坚持 下了就能用 原则,让客户花了钱觉得值
上班时间 : 周一至周五9:00-17:30 期待您的加入