Convert Msde Database To Sql

[un4given1]

I am using Windows 2003 Small Business Server 2003 Premium with SQL 2000. SharePoint Services is installed by default to use an MSDE database. I would like to convert it to a SQL database. Has anyone ever done this? Does anyone have any information that might help me?

[wullieb1]

I don't have any experience in doing this but you might want to try this m8

http://www.soft32.com/download_77491.html

[un4given1]

Thank you much for the reply. What I am looking at doing is a little more than just the conversion. It also has to do with making sure that SharePoint Services uses it after the conversion.

[wullieb1]

Didn't think it was what you were looking for m8. Leave it with me and i'll have a dig around

[Marsden]

You can upgrade the existing MSDE 2000 to SQL Server. The SQL Server installation program recognizes an installation of MSDE 2000 and its accompanying data files and transaction logs. This allows you to upgrade MSDE 2000 directly to SQL Server.

For more information, visit the following Microsoft Web site:

Upgrading an Existing Installation of SQL Server

http://msdn.microsoft.com/library/default....=/library/en-us /instsql/in_overview_2xtf.asp

[Marsden]

More options

You can detach the MSDE 2000 data file, and then attach it again on a computer running SQL Server. For information, visit the following Microsoft Web sites:

sp_attach_db

http://msdn.microsoft.com/library/default....=/library/en-us /tsqlref/ts_sp_ae-az_52oy.asp

sp_detach_db

http://msdn.microsoft.com/library/default....=/library/en-us /tsqlref/ts_sp_da-di_83fm.asp