Converting Sql DB to Sql Express for production
I've developed a site using sql 2005 as my Database server (Developer edition not express).
the IT department at my clients site wants to use Sql 2008 Express on the production server.
Is it possible to do this?
thank you
Hi Debbie Wright,
Yes, this can be done very easily - just detach the database from the sql 2005 server, then attach it to sql 2008 express and it will convert it by itself. However, make a back-up of the base before that, because once converted, there is no going back.
All the best,