Migrate 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 MySQL databases to SQL Server 2000.
Introduction
This guide explains how to migrate MySQL to Microsoft using several built-in SQL Server tools and utilities? SQL Server? 2000. It also provides instructions on how to modify MySQL applications to work with SQL Server 2000. If you have purchased a MySQL application, you can continue to make the investment take effect and provide SQL Server 2000 advanced functions for the application structure.
Target audience
The readers of this white paper may be those who are new to SQL Server and their operations, but should be very familiar with the concepts of MySQL DBMS and common databases. Target readers must have a general knowledge of database management.
Adequate basic knowledge of MySQL DBMS.
Familiar with MySQL.
It is a member of the sysadmin fixed server role. The sysadmin role has full control over the server. For more information about logging on to SQL Server, see "log on" in SQL Server 2000 online books.
To make the description clear and easy to understand, the benchmark development and application platform used is Microsoft Windows? 2000 operating system and SQL Server 2000. The MySQL ODBC driver is used with MySQL. The MySQL platform uses Red Hat Linux 7.1 of MySQL 3.23.37.
Overview
MySQL is an open-source database management system (DBMS ). It adopts the client/server structure and is a multi-threaded, multi-user database server. MySQL is designed for high-speed applications. Therefore, it does not provide many functions provided by the relational database system, such as subqueries, foreign keys, integrity of references, stored procedures, triggers, and views. In addition, it has a locking mechanism, which is not enough for data tables with different users performing many write operations at the same time. It also lacks support for software applications and tools.
SQL Server 2000 is a complete relational database management system (RDBMS). It also includes integrated analysis functions for OLAP and data mining. SQL Server 2000 meets the data and analysis storage requirements of the largest data processing system and commercial Web sites, and provides easy-to-use data storage services for individuals and small businesses.
The structure of Microsoft SQL Server supports advanced Server functions, such as row-level locking, advanced query optimization, data replication, distributed database management, and analysis services. Transact-SQL (T-SQL) is an SQL language supported by SQL Server 2000.
The structural features mentioned in this chapter are only part of the many features provided by SQL Server 2000. SQL Server 2000 online books are a useful resource that can be used to install applications. To use online books, open the Microsoft SQL Server Program Group and click online books ".
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
