By jbonnie on
Sunday, April 23, 2006 11:11:49 AM
Transferring SQL 2005 database (from another SQL 2k5 DB) is kinda a pain in the butt the way accounts are set-up on discountasp.net . For those of you whose familiar w/ SQL 2000, you would expect that SQL Import / Export wizard in SQL 2k5 will do the job. BUT that's not the case.SQL 2k5's Import/Export wizard do not transfer all database objects, it will only transfer Table, Views and data but not Stored Procs, UDF, relationships, etc.transferring with SSManagement Studio1) Log into the SQL Server where the source database resides with SQL Management Studio2) Right-Click on the database, Select Tasks, and Select Generate Scripts. The Script Wizard will pop up.3) Highlight the database your want to transfer in the next screen. Click Next button4) Choose Script Options Box will appear - Leave Defaults and change “Generate Script for Dependent Objects” = TRUE "Script Collation"= TRUE"Script USE DATABASE" = TRUENOTE *** if you have full text indexes in your database, change"Script Full-Text Indexes" = TRUE Click...
Read More »