First, first, I am talking about this access2000, SQL2000 conversion method I am also seen online, because I don't need it, so I haven't going to try again.
Second, the method of conversion
1. Open the "Database Source" in the Administrative Tools under the Control Panel;
2. Press "Add" to add a new data source, select "Driver do Microsoft Access (* .mdb" in the selection bar, one box will appear after completion,
In the "Database Source", enter the name you want to write, I am named "abc", indicating that you don't need to fill, then follow the choices, look for your database address and selection (note, please first
Back up your own Access database) and then determine.
The data source is built here, and the remaining is converted.
3. Open SQL2000 Enterprise Manager, enter the database, create a new empty database "ABC";
4. Select the newly established database, right-click, select "Import Data" under "All Tasks", press "Next" to continue;
5. In the database source, DRIVER DO Microsoft Access (*. MDB) ", in" User / System DSN ", select" ABC "you just added, press" Next ";
6. "Destination" does not need to be modified, select the server (generally "local", you can also select the server address or
LAN address, determine if your permissions can be operated, "Use Windows Authentication" means that "Using SQL Identity Operation Verification" can be used for the operation of the website, recommended the latter;
7. After selecting "Use SQL Identity Operation Valid", fill in your username and password, I choose the system default number "sa", "****", database selection "ABC", press " Next step ";
8, this step two single options, "from the data source replication table and view" and "data to be transmitted by a query command", select the former, press "Next" to continue;
9, here will appear in your own Access database, follow the "All Choice", next step;
10, "DTS Import / Export Wizard", see "Running" is selected as "next step",
11. Continue by "Complete";
12, this step you will see that your data is imported into SQL2000, when "has successfully imported XXX a table imported into the database", and all the table has a green hook, it means successfully imported all data, If there is a problem in the middle or a red fork in front of the table, it means that the table does not have successfully imported, then go back to see if your own operation is correct.
Third, data modification
1. Since there is no "automatic number" inside SQL2000, you will become a non-empty field with the fields set "Auto Number", which must be manually modified and the "marked" "Yes", The seed is "1", the increment is "1",
2, in addition, the Access 2000 is converted to SQL2000, the original attribute "Yes / No" will be converted into non-empty "bit", and you must modify the properties you want;
3, in addition, everyone should pay attention to the grasp of the time function. There are many differences between Access and SQL.
