November 24, 2005 at 8:10 am
How do I convert a SQL Server 2000 database to a SQL Server 2005 database?
November 24, 2005 at 11:34 pm
have you tried taking a back up and restoring it to your SQL 2005 instance, it's worked for me so far.
regards,
Mark Baekdal
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
November 25, 2005 at 8:23 am
The process worked for me too.
However, you may still need to configure SQL suface area properly to make all your SPs work. Some features like xp_cmdshell is turned off by default
November 25, 2005 at 10:01 am
You shouldn't have any problems James, backups have been able to restore automatically since at least SS2K5 beta 2. Microsoft tend to get features like that working and stable first - no easy upgrade path means no sales, so it's a pretty essential feature. Might be worthy of an article though (hint!) if you have the time to describe any problems you hit.
Jon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply