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

This article introduces you how to achieve downgrade in the SQLServer database, the content is very detailed, interested friends can refer to, hope to be helpful to you.

How to realize SQLServer database downgrade

Example: my actual situation is: I attached the 05 library with SQLSERVER2008, and later found that the database could not be restored to the server's SQLSERVER2005 during deployment. I used the following two steps to achieve the database degradation [that is, the copy of database table structure, view, stored procedure and data].

To achieve database degradation, you must have the following conditions:

1) the native SQLSERVER is not the EXPRESS version, because the EXPRESS version of SQLSERVER does not support data import and export.

2) the server and the machine are in the same local area network, which is convenient for data export. Of course, you can also install a low version of SQLSERVER on the machine first, and after the database is degraded, restore it to the server with the low version library.

How to realize SQLServer database downgrade

To get back to the point, here are the specific operations:

1) right-click the hierarchical database, generate a script, and copy the generated script to the server's SQLSERVER to run [Runtime reports that no object exists, because the generated script is operated by ALTER by default, so change all ALTER to CREATE]. After completing this step, the table structure, view and stored procedures of the database have been copied to the server, and the next work is to export the data in the database to the server SQLSERVER.

2) right-click the target database, click to export the data, and you can complete the export of the data in the next step along the way. When you select objects in the process of exporting data, you only need to select a table. There is no data in the view, so there is no need to export data. In the course of my operation, there are read-only fields in some tables, so if you can't export the data directly, you can only OK the special tables and copy the data to the server separately.

On how to achieve degradation in the SQLServer database to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.