You can NOT use Copy Database Wizard when destination server is SQL Server Express Edition.
Use backup and restore instead but keep in mind database size must be less than 4 GB.
Try copying with DB scripts, Database >> Tasks >> Generate Scripts >>
Refer this link for additional info
http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/
Try using DATABASE publishing wizard to generate scripts with schema and data.
http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
No comments:
Post a Comment