Porting an Access database to Microsoft SQL Server 7.0

Summary: This article describes the procedures and tools for converting an Access database to a SQL Server database
Brief introduction
As the user's demand for enterprise-class high-performance databases grows, users often convert to a client-server environment in Microsoft SQL Server from the file-server environment of the Microsoft Access jet engine. Access Upsizing Wizard in Microsoft Office 2000 enables you to transfer data tables and queries to SQL Server 7.0. If you are using an earlier version of Access, you can first upgrade it to Access 2000 and then use the Upsizing Wizard in it to migrate your application to SQL Server.
This article can be a guide to porting Access 2000 to SQL Server if you are not too willing to implement porting with Access 2000 and Upsizing Wizard. Transferring an application on access first requires transferring the data to SQL Server, then transferring the query into the database, or transferring it to a SQL file for later execution. The last step to take is porting the application.
SQL Server tools used in database porting
SQL Server Manager (SQL Server Enterprise Manager)
SQL Server Manager allows enterprise-level configuration and management of SQL Server and objects in SQL Server. SQL Server Manager provides a powerful scheduling engine, a high degree of fault tolerance, and an embedded replication management interface. Using SQL Server Manager, you can implement the following features:
Managing connections and User licenses
Create a script program
Managing backups of SQL Server objects
Backing up data and transaction logs
Manage tables, views, stored procedures, triggers, indexes, rules, default values, and user-defined data types
Establish full text indexing, database diagrams, and database maintenance plans
Input and output data
converting data
Perform various network management tasks
On a computer with Microsoft Windows NT operating system, SQL Server Manager is installed by SQL Server Setup and defaults to the server component, while running Windows NT and Microsoft Windows 95 on the machine, it will be defaulted to the client side component. You will start the data transfer Service (Dts,data Transformation Services) from the graphical user interface of SQL Server Manager.
Data transfer Service (Database Transformation Services, DTS)
Data transfer services allow you to enter and output data between multiple heterogeneous data sources using a database based OLE architecture, or to transfer database and database objects between multiple computers that use SQL Server 7.0, and you can also use data transfer services to More easily build data warehouses and data centers in an online transaction processing system (OLTP).
DTS Wizard allows you to interactively create DTS packages that import, export, validate, and transfer data through OLE DB and ODBC. DTS Wizard also allows you to copy illustrations (schemas) and data between relational databases.