how to copy database and use to other system in sql server.

Question

how to copy database and use to other system in sql server.

i copied data base using script and its is done with issue is inside the table data is not there only table structure is there

how to solve this issue

Anjali Khan · Answer

Frnds not copied table data only procedure n function

Laxmidhar Sahoo · Answer

madam follow the below procedure to take script Choose the advance button from the bellow dialog box at the top select schema and data from the dropdownlist in the bellow dialogbox of option Type of data to script

Esakki Muthu · Answer

If the SQL server versions are same then just take a backup of your database (.bak file) and retore it in the new system. OR While generating the scripts choose Schema With Data option