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

What is the correct procedure for downgrading Server 2005 to 2000? I believe many inexperienced people are at a loss about it. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

The editor mainly describes to you the correct steps for importing SQL Server 2005 into SQL Server 2000, as well as a specific description of the relevant matters worthy of our attention in the actual operation, and the following introduction of the specific content of Server 2005 to 2000 downgrade.

To move from SQL Server 2005 to 2000:

1. Generate for SQL Server 2000 version of the database script

Manger studio of SQL Server 2005

Open object Explorer (if not, press F8) and connect to your instance

Right-click the library to go to SQL Server 2000

Task

Generate script

In the script Wizard, in Select Database, make sure you select the library you want to go to SQL Server 2000

Check "script all objects in the selected database"

In the next "Select script options", find the "script for the server version" item and select "SQL Server 2000"

Other options are set as needed

Finally, save the script to a .SQL script file

two。 Create the target database in 2000

In query Analyzer (or 2005 manger studio opening script file), connect to SQL Server 2000 and execute the script generated above. To create a new database

3. Import data from 2005 to SQL Server 2000 (that is, import data from SQL Server 2005 to SQL Server 2000 using SQL2000's Import and Export Wizard)

Manger studio of SQL Server 2005

Open object Explorer (if not, press F8) and connect to your instance

Right-click the library to go to SQL Server 2000

Task

Export data

In the Select data Source step of the SQL Server Import and Export Wizard, make sure you select the database you want to export

In the Select Target step, connect to SQL Server 2000 and select the library you created in step 2

In Select Source Table and Source View, select all tables

(note that id is ignored in mapping, otherwise the import will fail.)

Final completion

Extended reading

Preparations before uninstalling SQL Server 2005

You may want to save some databases in their current state. You may also want to save changes to the default database. If any of the above exists, make sure that the data is well backed up before you follow the steps in this article. Alternatively, save copies of all data and all log files. Save these copies to a folder other than the MSSQL folder. The MSSQL folder will be deleted during the uninstall process.

The files you must save include the following database files. These files are installed as part of SQL Server 2005:

Distmdl.* Master.* Mastlog.* Model.* Modellog.* Msdbdata.* Msdblog.* Mssqlsystemresource.* Northwnd.* (installation of this database is optional. ) Pubs.* Pubs_log.* Tempdb.* Templog.* ReportServer [$InstanceName] (this is the default database for ReportServer. ReportServer [$InstanceName] TempDB (this is the default tempdb for ReportServer. Delete the local security group as part of the uninstall process, and delete the local security group for the SQL Server 2005 component For more information, see the topic "setting up a Windows Service account" in SQL Server 2005 Books online, or visit the MSDN website

Save or rename the SQL Server Reporting Services folder

If you are using SQL Server Reporting Services with the installed SQL Server, save or rename the following folders and subfolders:

Default path\ Reporting Services Default path\ MSSQL\ Reporting Services Default path\ SQL Server instance name\ Reporting Services Default path\ 90\ Tools\ Reporting Services Note: Default path is the placeholder for% ProgramFiles%\ Microsoft SQL Server. If you use the Reporting Services configuration tool to configure the installation, the name may be different from the name in this list. In addition, the database may be located on a remote computer running SQL Server.

Stop all SQL Server services

It is recommended that you stop all SQL Server services before uninstalling SQL Server 2005 components. An active connection may prevent the uninstall process from completing successfully.

Use an account with the required permissions

Log in to the server using the SQL Server 2005 service account or an account with equivalent permissions. For example, log in to the server using a member account of the local administrators group

After reading the above, have you mastered the correct procedure for downgrading Server 2005 to 2000? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.