How to export/ import userschema in SQL server 2005?
Home > IT Answers > SQL Server > How to export/ import userschema in SQL serve...
Saimadhu
370 pts.
0
Q:
How to export/ import userschema in SQL server 2005?
SQL Server 2005, SQL Server backup, SQL Server snapshot backup
To export userschema in oracle, we can use expdp and impdp commands.

Do we have any commands to export/ import userschema in SQL server 2005?

Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.

 

 

 

ASKED: Nov 4 2009  7:14 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Right click on the database, select all tasks, then Generate SQL Script. This will allow you to select all the objects and put everythng into a single script.
Last Answered: Nov 4 2009  10:35 PM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0