I have the following situation: I have a production site running on SQL 2005 Express (only because it's free), and it's a reasonably big DB, and i'm always incredibly close to the 4 Gb limit. Every now and then I actually hit it and it's a big mess.
Now that SQL 2008 Express has 10Gb as a limit, I'm going to migrate.
The question is, if I just install SQL 2008, and attach the MDF file from 2005, will I have the 10 Gb limit? Or do I have to create a new Database from 2008, and then import the data?
If the latter, how do you recommend to do this import, what's the fastest and simplest way?
Thank you very much!