>I need to move the database and data I have here in SQL 7.0 to the client's server running SQL 2005 to begin beta testing. With other SQL versions, a script of the database and backup of the data have been sufficient. However, the client's IT staff say that procedure doesn't work with SQL 2005. What is the proper way to do this task? I don't even see an option to create a new database in SQL 2005 directly from the EM console.
You have to use SSMS 2005 (SQL Server Management Studio) to work with SQL 2005. It also works with previous versions of SQL Server.
--sb--