Move database

Hello,

What is the easiest way to move a database from one server to another with the all table structures, view and stored procedures?

Thanks,

For just the structure (not the data) you can create a create script for the database (in enterprise Manager, right click any object in the database and Generate SQL Script should be an option).

For everything, including data, you can detatch the database, move the physical database file, and then attach the database file in the new location.

DTS will also allow you to move data and tables.

|||Would Backup?Restore work for this?|||to restore structure and data, yes.