Home > IT Answers > SQL Server > How to export/ import userschema in SQL server 2005?
Saimadhu
455 pts.
 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.

 

 

 



Software/Hardware used:
ASKED: November 4, 2009  7:14 AM
UPDATED: November 4, 2009  10:35 PM
RELATED QUESTIONS
Answer Wiki:
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 Wiki Answer Submitted:  November 4, 2009  10:35 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _