How to to transfer a database to another server computer using 2008 management studio. I want to transfer the exact schema to another server computer.
lets I have database call CSharpCornerDb on TestPCServer, How to transfer CSharpCornerDb with all tables to the new server call TestPCServer2
Can someone assist me?
Loading
Jignesh TrivediPosted Feb 28, 2012, 5:03 AM
please refer,
http://www.mssqltips.com/sqlservertip/1910/transfer-sql-server-database-schema-objects-and-data-with-smo/
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/
good article..