MSAccess database migration to MSSQLServer7.0

Source: Internet
Author: User
Tags sql server query ole
Introduction With the increasing requirements for enterprise-level high-performance databases, users sometimes switch from the MicrosoftAccessJet engine file server environment to the MicrosoftSQLServer client server environment. The Access2000 promotion Wizard provided by MicrosoftOffice2000 allows you to migrate Access tables and queries to SQLServer7.0.

Introduction With the increasing requirements for enterprise-level high-performance databases, users sometimes switch from the Microsoft Access Jet Engine file Server environment to the Microsoft SQL Server customer/Server environment. The Access 2000 Promotion Wizard provided by Microsoft Office 2000 allows you to migrate Access tables and queries to SQL Server 7.0.

Introduction

With enterprise-level High Performance DatabaseWith the increasing requirements of Microsoft®Access Jet Engine file Server environment, switch to Microsoft SQL Server®Customer/server environment. The Access 2000 Promotion Wizard provided by Microsoft Office 2000 allows you to migrate Access tables and queries to SQL Server 7.0. If you are using an earlier version of Access, you can first upgrade to Access 2000, and then use the promotion Wizard MigrationTo SQL Server.

If you do not want to use the Access 2000 and promotion wizard MigrationThis document can be used as an Access application Migration. Access Application MigrationThe process requires that the data be imported into SQL Server 7.0, and then the Access Query MigrationTo DatabaseOr SQL file for later execution. MigrationThe last step Migration.

SQL Server MigrationTools

In SQL Server, there are several tools that can help you complete Access data and Application Migration.

SQL Server Enterprise Manager allows you to configure and manage SQL Server and SQL Server objects within the Enterprise. SQL Server Enterprise Manager provides a powerful scheduling engine, alarm management function, and a built-in copy management interface. With SQL Server Enterprise Manager, you can complete the following tasks:

Manage logon and user permissions.

Create a script.

Manage the backup of SQL Server objects.

Backup DatabaseAnd transaction logs.

Manage tables, views, stored procedures, triggers, indexes, rules, default values, and user-defined data types.

Create full-text index, DatabaseCharts and DatabaseMaintenance Plan.

Import and export data.

Convert data.

Executes various Web management tasks.

By default, the SQL Server installer installs SQL Server Enterprise Manager as part of the Server software on Microsoft Windows NT®The operating system is installed on a computer running Windows NT and Microsoft Windows 95 as part of the client software.®On the computer of the operating system. You can start data conversion Service (DTS) from the SQL Server Enterprise Manager interface ).

Data conversion Service (DTS) can be used not only to import and export data between multiple heterogeneous data sources based on the ole db architecture (such as Microsoft Excel spreadsheet, it can also be transmitted between multiple computers running SQL Server 7.0. DatabaseAnd DatabaseObject. You can also use DTS to convert the data into an appropriate form to create a data warehouse and a data mart from the online transaction processing (OLTP) system more conveniently.

DTS Import Wizard (DTS Import Wizard) and DTS Export Wizard (DTS Export Wizard) allow you to create DTS Packages interactively, import, export, verify, and convert heterogeneous data through ole db and ODBC. The two wizard also allows you DatabaseReplication between architectures and data.

SQL Server Query Analyzer is a graphical Query tool that allows you to analyze a Query plan, execute multiple queries at the same time, View data, and obtain recommended indexes. SQL Server Query Analyzer has a SHOWPLAN option to report the data retrieval method selected by SQL Server Query Analyzer.

SQL Server Profiler can capture continuous Server activity records in real time. SQL Server Profiler allows you to monitor events generated by SQL Server, filter events based on user-specified criteria, and direct Trace Output to screens, files, or tables. With SQL Server Profiler, you can play back previously captured traces. This tool helps application developers identify transactions that may reduce application performance. From the file-based architecture to the customer/Server Architecture MigrationThis feature is very useful for applications because MigrationThe last step involves optimizing applications for the new customer/server environment.

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.