I recently downloaded 2005 express. I am able to create a new database fine. But how do I take an existing database (created elsewhere) and make changes to it? For example, I want to make a copy of my mdf on my website and manipulate the data and design on express, then copy it back to the ftp server. What is the easiest way?
If this is a limitation of 'Express', can I do this with 2005 'developers' editon that costs $49??
You can backup a database from SQL 2000, then restore the database onto SQL 2005, but I don't know of any way to go back reliably. The SQL 2005 database engine supports (in many cases demands) structure changes that SQL 2000 can't support.