How to convert Sql server 2000 database backup file to Sql server 2005 Express Edition .mdf file.
-
Hi All, Is it possible to convert SQL Server 2000 database file to Sql Server 2005 .mdf file. If it is possible then please tell me how to do it. Thanx in Advance. Regards, Paramhans Dubey.
-
Hi All, Is it possible to convert SQL Server 2000 database file to Sql Server 2005 .mdf file. If it is possible then please tell me how to do it. Thanx in Advance. Regards, Paramhans Dubey.
You should be able to attach the SQL 2000 database file to SQL 2005. Have you tried attaching it?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
Hi All, Is it possible to convert SQL Server 2000 database file to Sql Server 2005 .mdf file. If it is possible then please tell me how to do it. Thanx in Advance. Regards, Paramhans Dubey.
Yes, you can restore a SQL Server 2000 database backup to a SQL Server 2005 server. You simply use the normal Restore features - use Management Studio or the
RESTORE DATABASEcommand. The compatibility level for the database will be 80 (i.e. SQL Server 2000 compatible) by default. If you want to take full advantage of SQL Server 2005 features, you will need to usesp_dbcmptlevelto set the compatibility level to 90.Stability. What an interesting concept. -- Chris Maunder
-
Yes, you can restore a SQL Server 2000 database backup to a SQL Server 2005 server. You simply use the normal Restore features - use Management Studio or the
RESTORE DATABASEcommand. The compatibility level for the database will be 80 (i.e. SQL Server 2000 compatible) by default. If you want to take full advantage of SQL Server 2005 features, you will need to usesp_dbcmptlevelto set the compatibility level to 90.Stability. What an interesting concept. -- Chris Maunder
hi friends, As I have mentioned earlier I m using SQL Server 2005 Express Edition, So I don't have Management Studio. I tried following restore command : "
Restoring SQL Server 2000 Database *.bak backup file to SQL Server 2005 Express Edition *.mdf file RESTORE filelistonly FROM disk = 'C:\Documents and Settings\Administrator\Desktop\ImageDB.bak' RESTORE DATABASE image FROM disk = 'C:\Documents and Settings\Administrator\Desktop\ImageDB.bak' WITH move 'ImageDB' TO 'C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplication1\Image.mdf', move 'Image_log' TO 'C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplication1\Image.ldf'" But I am unable to find any mdf or ldf file in the directory "C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplication1". I also searched the directory ” C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data” but that was also of no use. Regards, Paramhans Dubey.