|
Article relates to
|
Sitefinity 3.x
|
|
Created by
|
Vladimir Vasilev
|
To migrate the Sitefinity database from SQL Server 2005 to SQL Server 2000, do the following:
1. Generate a database script in Microsoft Server Management Studio > Script Wizard:
2. At the
Options step, select
SQL Server 2000 for
Script for server version:
3. At the
Object Types step, choose to script
Stored Procedures,
Tables and
Functions:
4. Open the script generated at step 1 in a text editor and replace the following in it:
Replace nvarchar(max) with ntext
Replace [nvarchar](max) with [ntext]
Replace varbinary(max) with image
Replace [varbinary](max) with [image]
5. Create a new database in SQL Server 2000 and run the script generated at step 2 and modified at step 4.
6. Download and install the
Database Publishing Wizard tool.
7. Open SQL 2005 database in the Database Publishing Wizard and generate a script with the following options to script data only:
8. Run the script generated at step 7 into the SQL Server 2000 database.
9. Open the application web.config.
10. Change the connections string to point to the SQL Server 2000 database.
11. Change the Nolics data providers in the
dataAccess section:
| <dataAccess defaultConnection="DefaultConnection"> |
| <connections> |
| <add name="DefaultConnection" driver="Nolics.ORMapper.DataProviders.SqlServer2000Provider” |
| connectionStringName="Sitefinity" /> |
| <add name="GenericContentConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2000Provider, Telerik.Cms.Engine.Data" |
| connectionStringName="Sitefinity" /> |
| </connections> |
| |