如何将MS Access数据库迁移到SQL SerVer [英] How can migrate the MS Access Database to SQL SerVer

问题描述

大家好，



我想设计一个软件，使用C＃将MS Access数据库迁移到SQL Server。但现在我没有解决我的问题。所以如果你有一个理想或者我的问题的代码，请告诉我。



谢谢。

Hi All,

I want to design a software migrate the MS Access Database to SQL Server by using C#. But now i don't have any solutions for my problem. So if you have an ideal or soure code for my problem, pls let me know.

Thanks.

推荐答案

您好，



请参考下文。



http://sqlmag.com/database-administration/15-steps-convert-access-data-sql-server [ ^ ]



https://msdn.microsoft.com/en-us/library/hh313039(v = sql.110）.aspx [ ^ ]



http://databases.about.com/od/tutorials/ HT /转换-An-Access-Database-To-SQL-Server.htm [ ^ ]

Hi,

Please refer below .

http://sqlmag.com/database-administration/15-steps-convert-access-data-sql-server[^]

https://msdn.microsoft.com/en-us/library/hh313039(v=sql.110).aspx[^]

http://databases.about.com/od/tutorials/ht/Converting-An-Access-Database-To-SQL-Server.htm[^]

除了Solution1之外，你可以参考这里，

http://blogs.office.com/2012/02/17/five-common-pitfalls-when-upgrading-access-to-sql-server/ [ ^ ]

点击此链接中的屏幕截图：

http://microsoft-sql-server-migration-assistant.software.informer.com/4.2/ [ ^ ]

http://www.ssw.com.au/ ssw / upsizingpro / SQL_Server_Migration_Assistant_Wizard_for_Access.aspx [ ^ ]

Addition to Solution1 you may refer here,
http://blogs.office.com/2012/02/17/five-common-pitfalls-when-upgrading-access-to-sql-server/[^]
Follow the Screenshot in this link:
http://microsoft-sql-server-migration-assistant.software.informer.com/4.2/[^]
http://www.ssw.com.au/ssw/upsizingpro/SQL_Server_Migration_Assistant_Wizard_for_Access.aspx[^]

使用SSIS：



6709670 /使用-SSIS包怎么办 - 我 - 导入 - MS-访问数据为-SQL服务器http://stackoverflow.com/questions/6709670/how-do-i-import-ms -access-data-into-sql-server-using-ssis-package [ ^ ]

Use SSIS :

http://stackoverflow.com/questions/6709670/how-do-i-import-ms-access-data-into-sql-server-using-ssis-package[^]

这篇关于如何将MS Access数据库迁移到SQL SerVer的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！