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.