Installation and deployment
Version 3.x > Installation and deployment > Develop and export from sql server 2000 then import and run on sql server 2005 View modes: 
User avatar
Member
Member
GMichalek-cogeco - 10/14/2008 5:08:12 PM
   
Develop and export from sql server 2000 then import and run on sql server 2005
I currently use the msde 2000 db on my development machine but will be installing sql server 2005 on my vps as soon as the media arrives. I want to be able to continue working while waitng for the sql server to arrive. Can I develop on my development machine and then export the project and then take this exported project and import it on my vps even though the original development is sql server 2000 and the target implementation is sql server 2005?

Any help would be greatly appreciated.

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 10/15/2008 1:35:50 AM
   
RE:Develop and export from sql server 2000 then import and run on sql server 2005
Hi,

I think that the SQL Server 2005 has backward compatibility with SQL Server 2000. So I don't see any problems with developing on SQL 2000 and then restoring the DB on SQL 2005. For more details please see http://www.microsoft.com/sqlserver/


Best Regards,
Juraj Ondrus

User avatar
Member
Member
GMichalek-cogeco - 10/15/2008 7:05:03 PM
   
RE:Develop and export from sql server 2000 then import and run on sql server 2005
Thanks. Rather than taking the risk I have decided to un-install and then re-install with sql 2005 specified as the database.