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

This article mainly introduces "how to convert MSSQL2005 into MSSQL2000". In daily operation, I believe many people have doubts about how to convert MSSQL2005 into MSSQL2000. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the questions of "how to convert MSSQL2005 into MSSQL2000". Next, please follow the editor to study!

To convert SQL2005 to sql2000. The biggest problem is to re-implement the functionality implemented with the SQL2005 feature in SQL2000.

1. Conversion of the table.

Do not use the generated script tool that comes with SQL2005 to convert, because there is a BUG. When you do not select "script all selected objects", his version selection will go wrong, even if you select SQL2000 in "script the server version". He also writes scripts for SQL2005.

Therefore, it is recommended to use the Microsoft sql server database publishing wizard tool, which is more convenient to use.

But he has a disadvantage that the error prompt is not detailed enough, so it can be used in combination with the two.

According to his error prompt, modify some field types in SQL2005 to conform to the SQL2000 standard. Then the generated script is executed in SQL2000. Just do it. (it is best to choose to convert only the table structure, and the data is imported next time)

two。 View conversion

After the table conversion is successful, this step is easy to convert.

3. Function conversion

In the tool, select all the functions, generate the script, execute in sql2000, find out the unsuccessful functions, and modify them into statements that conform to the sql2000 standard.

4. Stored procedure conversion

Again, follow the third step

5. Other

The functions that sql2000 does not have, such as assemblies and stored procedures implemented in C #, have to be implemented again with sql statements.

6. Data conversion

In some cases, importing data into sql2000 with MSSQL2005 will result in an error. And the MSSQL database publishing wizard tool cannot generate a data insertion script.

Then you can first use the tool to generate a script for inserting data into MSSQL2005. And then execute it in MSSQL2000. It can be executed under normal circumstances. If individual tables report errors, delete the insert statements for those tables first. And then execute it.

At this point, the conversion has been completed successfully.

The more sql2005 features you use in MSSQL2005, the more you will understand the 2005 superior performance.

CTE,TRY_CATCH statement, ouput substatement, error_message. Wait, wait. it's all after SQL2005.

At this point, the study on "how to convert MSSQL2005 into MSSQL2000" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.