SQL Server 2005 downgrade to 2000 the correct procedure to share _mssql

The following articles mainly describe the correct steps for SQL Server 2005 import into SQL Server 2000, as well as the specific description of the related matters that deserve our attention in the actual operation, the following is the introduction of the specific content of the article, hope you will have a harvest.

SQL Server 2005 go to 2000 steps:

1. Generate a For SQL Server 2000 version of the database script

Manger Studio for SQL Server 2005

Open Object Explorer (no words pressed F8), connect to your instance

Right-click to go to the Library of SQL Server 2000

Task

Generating scripts

In the Script wizard, select Database, and make sure that you selected the library that you want to go to SQL Server 2000

Write script for all objects in the selected database

In the next select script options, locate the script for server version entry, and select SQL Server 2000

Other options are set as needed

Finally, save the script to a. SQL script files

2. Create the target database in 2000

In Query Analyzer (or 2005 of Manger Studio opens the script file), connect to SQL Server 2000 and execute the script generated above. To create a new database

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

Manger Studio for SQL Server 2005

Open Object Explorer (no words pressed F8), connect to your instance

Right-click to go to the Library of SQL Server 2000

Task

Export data

In the Select data source step of the SQL Server Import and Export Wizard, determine which database to export is selected

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

In Select source table and Source view, select all tables

(Note that the ID selection is ignored when mapping, otherwise the import fails)

Finally completed

The above article mainly describes the actual steps of SQL Server 2005 to 2000.

Extended Reading

Pre-uninstall SQL Server 2005

You may want to save some databases in the current state. You may also want to save changes to the default database. If any of these conditions are true, make sure you have a good backup of the data before you follow the steps in this article. Or, save all the data and a copy of all the log files. Save these copies to a folder other than the MSSQL folder. During the uninstall process, the MSSQL folder will be deleted.

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.* (the installation of this database is optional.) ）
pubs.*
pubs_log.*
tempdb.*
templog.*
reportserver[$InstanceName] (this is the default database for the Server. ）
reportserver[$InstanceName]tempdb (This is the default staging database for the Server. ）
Delete Local security group
As part of the uninstall process, delete the local security group for the SQL Server 2005 component. For more information, see the "Setting up Windows Service Accounts" topic in SQL Server 2005 Books Online, or visit the following MSDN Web site:

Http://msdn2.microsoft.com/zh-cn/library/ms143504.aspx (http://msdn2.microsoft.com/zh-cn/library/ms143504.aspx)

Save or rename the SQL Server Reporting Services folder

If you are using SQL Server Reporting Services with SQL Server installed, 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 a placeholder for%programfiles%\microsoft SQL Server. If you use the Reporting Services Configuration tool to configure the installation, the name may differ 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 the SQL Server 2005 component. Active connections may cause the uninstall process to complete successfully.

Use an account with the required permissions

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