database copy
i want to copy all the table ,stored procedure,view one database to another database with its all the data how i will do plz help me
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pankaj PandeyPosted May 8, 2013, 7:16 AM
second one show all script of stored procedure in table, just copy script and paste in new database and run.
http://www.c-sharpcorner.com/Blogs/11154/query-to-copy-all-tables-from-one-database-to-another-or-dum.aspx
http://www.c-sharpcorner.com/Blogs/11606/get-definitionscript-of-all-stored-procedures.aspx
thanks..
Jay SPosted May 8, 2013, 6:47 AM
On new Db > Right Click > Restore