Migrate MySQL to Microsoft SQL Server 2000 (1)-Database related-PHP tutorial_PHP tutorial

Migrating MySQL to Microsoft SQL Server 2000
Abstract
This white paper describes the migration capabilities of Microsoft SQL Server 2000 and provides specific information to help developers migrate MySQL databases to SQL Server 2000.
Introduction
This guide explains how to migrate MySQL to Microsoft® SQL Server® 2000 using several built-in SQL Server tools and utilities. It also provides guidance on how to modify MySQL applications to work with SQL Server 2000. If you purchase MySQL Applications, you can continue to leverage that investment while providing the advanced capabilities of SQL Server 2000 to your application architecture.
Target audience
The readers of this white paper can be people who are new to SQL Server and its operation, but should be very familiar with the concepts of MySQL DBMS and ordinary databases. The target reader must have: General knowledge of database administration.
Sufficient basic knowledge background of MySQL DBMS.
Familiar with MySQL language.
Membership in the sysadmin fixed server role. The sysadmin role has full control over the server. For more information about logging into SQL Server, see the "Login" section of the SQL Server 2000 Books Online.
To keep the instructions clear and understandable, the baseline development and application platforms used are Microsoft Windows® 2000 operating system and SQL Server 2000. The MySQL ODBC driver is used with MySQL and the MySQL platform is Red Hat Linux 7.1 using MySQL 3.23.37.
Overview
MySQL is an open source database management system (DBMS). It adopts a client/server structure and is a multi-threaded, multi-user database server. MySQL is designed for high-speed applications, and therefore, it does not provide many of the features provided by relational database systems, such as subqueries, foreign keys, referential integrity, stored procedures, triggers, and views. In addition, it has a locking mechanism, which is not enough for data tables with many write operations 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 analytic capabilities for OLAP and data mining. SQL Server 2000 meets the data and analysis storage requirements of the largest data processing systems and commercial Web sites, while providing easy-to-use data storage services for individuals and small businesses.
Microsoft SQL Server is architected to support advanced server features such as row-level locking, advanced query optimization, data replication, distributed database management, and analysis services. Transact-SQL (T-SQL) is the SQL language supported by SQL Server 2000.
The structural features mentioned in this chapter are just some of the many features provided by SQL Server 2000. The SQL Server 2000 Books Online is a useful resource to leverage when installing applications. To use Books Online, open the Microsoft SQL Server program group and click Books Online.