3
Answers

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

Anjali Khan

Anjali Khan

7y
172
1
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
Answers (3)
0
Anjali Khan

Anjali Khan

NA 738 42.2k 7y
Frnds
 
not copied table data only procedure n function
0
Laxmidhar Sahoo

Laxmidhar Sahoo

NA 2.3k 1.4k 7y
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
 
 
0
Esakki Muthu

Esakki Muthu

NA 882 342 7y
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