migrating MySQL to Microsoft SQL Server 2000
Summary
This white paper describes the migration capabilities of Microsoft SQL Server 2000 and provides specific information to help developers migrate the MySQL database to SQL Server 2000.
Introduction
This guide explains how to use several built-in SQL Server tools and utilities to migrate MySQL to Microsoft? SQL Server? 2000. It also provides guidance on how to modify the MySQL application to work with SQL Server 20,001. If you purchase a MySQL application, you can continue to make this investment work, while providing advanced features of SQL Server 2000 for the application architecture.
Reader Object
The reader of this paper can be a person who has just contacted SQL Server and its operations, but should be familiar with the concepts of MySQL DBMS and normal database. The target audience must have: general knowledge of database management.
Sufficient background for MySQL DBMS fundamentals.
Familiar with MySQL language.
Membership with the sysadmin fixed server role. The sysadmin role has full control over the server. For more information about logging on to SQL Server, see the "Sign in" section of the SQL Server 2000 Books Online.
To make the instructions clear, the baseline development and application platform used is Microsoft Windows? 2000 operating systems and SQL Server 2000. MySQL ODBC driver is used with MySQL, MySQL platform is Red Hat Linux 7.1 using MySQL 3.23.37.
Overview
MySQL is an open source database management system (DBMS). It uses the client/server structure and is a multi-threaded, multiuser database server. MySQL is designed for high-speed applications, so it does not provide many of the features that relational database systems provide, such as subqueries, foreign keys, referential integrity, stored procedures, triggers, and views. In addition, it has a locking mechanism, which is not enough for a data table that has a lot of writing done by different users at the same time. It also lacks support for software applications and tools.
SQL Server 2000 is a complete relational database management system (RDBMS) that also includes integrated analysis capabilities for OLAP and data mining. SQL Server 2000 meets the storage requirements for data and analytics for the largest processing systems and commercial WEB sites, while providing easy-to-use data storage services for individuals and small businesses.
The structure of Microsoft SQL Server supports Advanced Server features such as row-level locking, Advanced query optimization, data replication, distributed database management, and Analysis Services. Transact-SQL (T-SQL) is a SQL Server 2000 supported language.
The structural features mentioned in this chapter are only part of the many features provided by SQL Server 2000. SQL Server 2000 Books Online is a useful resource to use when installing an application. To use Books Online, open the Microsoft SQL Server program group and click Books Online.
http://www.bkjia.com/PHPjc/631440.html www.bkjia.com true http://www.bkjia.com/PHPjc/631440.html techarticle migrating MySQL to Microsoft SQL Server 2000 Summary This white paper describes the migration capabilities of Microsoft SQL Server 2000 and provides help for developers migrating MySQL databases to SQL Se ...
