MySql与Sql Server数据转换研究与实现

Research and Implementation of Data Conversion about MySql and Sql Server

各种应用系统都具备数据库的支持,其中MySql与Sql Server是数据库应用的代表。用户需求的不断变化,在系统运行实践中经常会遇到数据转换的要求。MySql与Sql Server存在的差异使得这种转换没有统一、通用的方法存在。在分析二者之间数据转换各种方法的基础上,研究并实现了在特定用途中的数据转换。在开发应用程序项目中,综合目前转换方法的优势,弥补了转换方法的不足,得到更加适合项目实际的数据转换方法,并成功在项目开发中得到应用。

All kinds of application system have databases, and MySql or Sql Server is more important. As we all know, it is ordinary to transfer database when application system is running for requirement being changed. There isn＇t unified transfer method from MySql to Sql Server. On the base of analysis about data conversion among these two different databases, researching and getting the way for specially using. At the development of our project, compositing the advantage of current data Conversion methods, and making up the disadvantage of data change, it is the better way for our project about the data change and it work very well during the project running.