SQL Migration and MSDN Access

  • Hello friends,

    Just brought to my attention with the following:

    "The MSDN subscription we need is xxxxxxxx and the cost will be $xxxx.xx. We need this to move forward with the enhancements for existing MS Access database migration to migrate to ASP .net 3.5 and Visual Studio 2008. We are currently at ASP .net 1.1 and Visual Studio 2005 which is about 3 years old and much more has come out as far as enhancements in 2008."

    My questions is migrating the Access DB into SQL 2005 is really the old thing already? What are the business implications behind this may be or any technical compliance issue? Please share your knowledge and experience. I am trying to educate myself in this. I appreciate your time.

  • Hello,

    SQL Server 2005 is a current version and SQL Server 2005 exists only in CTP, not a released version. I would migrate data from MS ACCESS to SQL server 2005 if your project needs it. It will be easy to upgrade the 2005 database to 2008 when SQL Server 2008 is released. But if you would like to save money and not to pay for MSDN subscription, you may would like to buy SQL Server 2005 Developer Edition to start your development and when SQL Server 2008 is released soon, you will buy SQL Server 2008 for your production.

    Regards,Yelena Varsha

  • Hi Yelena,

    Thank you for your response. I appreciate it very much.

    -Sanjeev

  • I am curious as to why you would need an MSDN subscription to do any of that work. MSDN has nothing to do with a database.

    All you need to do is re-code your database connection and all your current recordsets. You will use different classes in your programming language.

    Andrew SQLDBA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply