un4given1 Posted March 17, 2005 Share Posted March 17, 2005 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? Link to comment Share on other sites More sharing options...
wullieb1 Posted March 17, 2005 Share Posted March 17, 2005 I don't have any experience in doing this but you might want to try this m8http://www.soft32.com/download_77491.html Link to comment Share on other sites More sharing options...
un4given1 Posted March 17, 2005 Author Share Posted March 17, 2005 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. Link to comment Share on other sites More sharing options...
wullieb1 Posted March 17, 2005 Share Posted March 17, 2005 Didn't think it was what you were looking for m8. Leave it with me and i'll have a dig around Link to comment Share on other sites More sharing options...
Marsden Posted March 17, 2005 Share Posted March 17, 2005 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 Serverhttp://msdn.microsoft.com/library/default....=/library/en-us /instsql/in_overview_2xtf.asp Link to comment Share on other sites More sharing options...
Marsden Posted March 17, 2005 Share Posted March 17, 2005 More optionsYou 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_dbhttp://msdn.microsoft.com/library/default....=/library/en-us /tsqlref/ts_sp_ae-az_52oy.aspsp_detach_dbhttp://msdn.microsoft.com/library/default....=/library/en-us /tsqlref/ts_sp_da-di_83fm.asp Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now