MS Access数据库转换为Mysql数据库 [英] MS Access databases to convert to a Mysql database

问题描述

好吧，所以我在MS Access中拥有了这个数据库，我想将其放入mysql数据库中，当我这样做时，我的数据库在mysql中看起来是什么样的，它将所有的表都转换成mysql的外观和命令吗?我假设那看起来不会像Access女士那样.

Ok so I have this database in MS Access and I want to put it into a mysql database, when I do that what does my database look like in mysql does it convert all of my tables into mysql look and commands? I am assuming that is will not look like the Ms Access does. Also is it easier to make a database in MS Access and convert or just use the mysql right off the bat?

推荐答案

好吗，这取决于您的操作方式.您可以保留相同的表，也可以重新设计表.另外，您可能希望基于目标数据库的功能来更改设计.

如果您要进行快速移植，而又没有时间进行重大重新设计，请保持相同. MySQL应该支持Access所做的一切，因此您不太可能遇到任何问题.

Well that depends on how you do it. You could keep the same tables or you could redesign the tables. Also you might want to change your design based on the capabilities of the target database.

If you are doing a quick port, and you don''t have time for a major redesign, just keep things the same. MySQL should support everything that Access did, so it''s unlikely that you will hit on any problems.

这里的文章可以回答您的某些问题，并希望可以帮助您解决所有问题.过渡.

从Microsoft SQL Server迁移并访问MySQL [从MS Access迁移到MySQL [访问MySQL [

Here are an article that can answer some of your question and hopefully helps you through the transition.

Migrating from Microsoft SQL Server and Access to MySQL[^]
Migrating From MS Access To MySQL[^]

I don''t how much helpful it would be, there is even a tool that can convert it for you
Access To MySQL[^]

这篇关于MS Access数据库转换为Mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！