Express does byde fault support Data Transformation Services or its replacement Integration Services. Some people ahve been able to get it to work by downloading the Advanced Express pack. However thats not really going to help you with the webs erver problem as much.
You can just detach the database and copy it, you could also search for the database publishing wizard on the Microsoft site and also on http://www.codeplex.com
|||I just got some more information. apparently a database dump gets done at night on to an SQL 2000 server. What sort of conversion needs to be done to make the database compatible with 2000?
So SQL Express is dumping a database on to a 2000SQL server.
|||There is not an easy way of taking a SQL2005 database and loading it onto a SQL2000 Server with express. SSIS is your best shot, there are some threads from a while back on import/export with express.