database copy

Question

i want to copy all the table stored procedureview one database to another database with its all the data how i will do plz help me

Pankaj Pandey · Answer

If you want to do it by query follow my given blogs. 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 S · Answer

Right Click on DB > Backup On new Db > Right Click > Restore