Shulou(Shulou.com)05/31 Report--

This article mainly explains "the steps of converting virtual host ACCESS to MSSQL". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the steps of converting virtual host ACCESS into MSSQL.

I. basic premise

1. The virtual host you use supports MS SQL. You must first find out from the virtual host provider whether the virtual host you purchased supports MS SQL. Hosting providers will generally give you MS SQL information such as the following after you buy a virtual host:

Host IP: 218.5.XX.XXX of the database

Database name: XXXXXX

User name of the database: XXXXXX

Database password: XXXXX

Space size of the database: XX

If your virtual host supports MS SQL, but you do not know the above information, please ask the host provider first.

2. You have to install Sql Enterprise Manager on your computer (please click to download practical installation-free green software)

3. Internet conditions (needless to say, of course).

II. Setting up

Before you begin the conversion, you need to make the following preparations:

Download the latest ACCESS database you are about to convert from the server. In the MAXZ movie system, if you do not rename the database, the database is datas.asp in the INC directory. After downloading to your local computer, right-click on the datas.asp file name and rename it to datas.mdb. In this way, the original ACCESS database you want to convert is ready, please remember where to store it.

2. In the SQL Enterprise Manager-SQLgreeMGMT folder that you downloaded and unzipped, click "Sql Green Edition Manager" → "GSqlAdmin.exe", SQL Manager, and connect to the local SQL server. After startup, it is shown in the figure:

3. Then go to the key configuration program: click "tools" in the menu bar of the "Sql Green Edition Manager" window, right-click "Enterprise Manager" in the window that appears, and appear "Registration-Enterprise Manager". Click "Registration-Enterprise Manager":

The DOS window appears as shown in the figure:

After the DOS window disappears automatically, left-click Enterprise Manager to start SQL SERVER ENTERPRISE MANAGER:

4. Right-click the SQL SERVER group shown above, and click the "New SQL SERVER Registration" that appears. In the window that appears, click next:

Fill in your MS SQL database host IP address or name in the space under "available servers" in the new window (as discussed in the basic premise of part 1). After filling in the IP address, click "add" below to add the IP address to the server. Then click "next" below:

5. Select the SQL SERVER authentication entry as shown in the following figure, and then click "next":

6. Fill in the user name and password of your MS SQL database in the new window:

7. Click "next" in the window that appears:

8. Click "finish" in the "complete Registration" window:

9. If there is nothing wrong with the above operation, after a while, the window of successful server registration will appear. At this point, the configuration is over, and you can enter the conversion phase.

III. Conversion

After the configuration is successful, return to SQL SERVER ENTERPRISE MANAGER, and your MS SQL database name (IP address or database name) will appear under the SQL SERVER group. Click the database name under the SQL SERVER group, click "Import data" in "data conversion Service" under "tools" at the top, and click "next"

Select MICROSOFT ACCESS in the window that appears, and click next. Well, congratulations, the conversion is about to be successful!

At this point, I believe you have a deeper understanding of the "virtual host ACCESS to MSSQL conversion steps", might as well come to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.