SSMS 2008 express - limits?

Hi everyone,

I've just signed up to DASP and am looking forward to hosting with you guys! I'm quite new to all this, so forgive the inevitable questions . Here's my current situation and I'm not quite sure what the best way to approach it would be.
- I've got a database, which was created in SQL Server Management Studio 2005.
- I want to migrate this database to SQL Server 2008 and I have ordered the addon
It seems that I need to have SSMS 2008 in order for me to attach my MDF file. If I download the express edition of SSMS 2008 what limits will be imposed (if any)? Will there be any conflicts for using a full version of SSMS to create my 2005 database and migrating it to an express edition of SSMS?

Thanks for any help!

 

Hi everyone,
Just a quick update. I managed to get the SQL Server up and, so far, it seems to be working. I'm just testing my DAL to see if it works. For those who are in the same position:

1) In SSMS 2005, I detached my database
2) I FTP'd the .MDF file onto my DASP server
3) I then used DASP's MDF Attach tool
4) Deleted the database off the server (the one I ftp'd over) and changed my connection string in my web.config

So far so good. I guess my only question now is, what are the limits of SSMS 2008 Express Edition? Since I only have 2005, I won't be able to access my DB without it.

 

Hi,
Good to see you got it working.
I've done a few webcasts on this already but probably need to create an updated one that covers the 2008 models.
You definitely want to use the 2008 version of SQL Express rather than 2005.
It gives you the updated import/export functions that even allow you to connect to your external SQL Server, very handy.
All the best,
Mark

 

Cool, downloading the Express edition as I type. I can also confirm that my database hasn't had any problems after testing my entire DAL. Great stuff!