Many friends want to use SQL2000 database programming methods, but they suffer from the fact that they are learning ACCESS and only have a little understanding of SQL. Here I provide you with the following reference---Methods and precautions for converting ACCESS into SQL2000.
1. First of all, what I’m talking about is converting between ACCESS2000 and SQL2000. I haven’t tried the other ones yet. I hope you can experiment more, and there must be a way;
2. Conversion method
1. Open "Database Source" in "Administrative Tools" under "Control Panel";
2. Click "Add" to add a new data source, and select "Driver do microsoft Access" in the selection bar.
(*.mdb)", a box will appear after completion,
Enter the name you want to write in "Database Source". I named it "ABC". There is no need to fill in the instructions. Then, press the selection below to find your database address and select it (note, please back up your ACCESS database first. ), then OK.
The data source is created here, and all that remains is conversion.
3. Open SQL2000 Enterprise Manager, enter the database, and create a new empty database "ABC";
4. Select the newly created database, right-click the mouse, select "Import Data" under "All Tasks", and click "Next" to continue;
5. Select "Driver do microsoft Access(*.mdb)" in the database source drop-down list. In "User/System DSN", select the "ABC" you just added and click "Next";
6. "Purpose" does not need to be modified. Select the server (usually your own machine "local", you can also select the server address or LAN address to determine whether your permissions can operate), "Use WINDOWS authentication" means use For your own system administrator identity operation, "Use SQL identity operation verification" can be used for website operations, and the latter is recommended;
7. After selecting "Use SQL identity operation verification", fill in your user name and password. I chose the system default numbers "sa" and "****". For the database, select the newly created "ABC" and press " Next step";
8. There are two single choices in this step, "Copy tables and views from the data source" and "Use a query command to specify the data to be transferred". Select the former and click "Next" to continue;
9. The tables of your own ACCESS database will appear here. Click "Select All" and go to the next step;
10. "DTS Import/Export Wizard", see that "Run Now" is selected and click "Next".
11. Press "Finish" to continue;
12. In this step, you will see your data being imported into SQL2000. When the words "XXX tables have been successfully imported into the database" appear, and there are green ticks in front of all tables, it means that all data has been successfully imported. If there is a problem along the way or there is a red cross in front of the table, it means that the table was not successfully imported. At this time, you need to go back and check whether your operation is correct.
3. Data modification
1. Since there is no "automatic numbering" in SQL2000, the fields you set with "automatic numbering" will become non-empty fields. In this case, you must manually modify these fields and select "Yes" for "Mark". The seed is "1", the increment is "1",
2. In addition, after converting ACCESS2000 to SQL2000, the fields with the original attribute "yes/no" will be converted into non-empty "bit". At this time, you must modify it to the attribute you want;
3. In addition, everyone should pay attention to the grasp of the time function. There are many differences between ACCESS and SQL.
Because there is no picture capture software, I do not show you pictures. Please forgive me.
My QQ number is: 310575. Welcome everyone to communicate with me.
My next article will be about converting SQL2000 to ACCESS2000, please stay tuned.