 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Other SQL Server Topics / August 2005export settings and security
hello, i m new to sql and i need to export all the settings of a base in sql 2000, security users ..., is it possible? do i just need to backup the database and all the settings will be saved? THX hi Marc, > hello, > i m new to sql and i need to export all the settings of a base in sql > 2000, security users ..., is it possible? do i just need to backup > the database and all the settings will be saved? each database contains it's full set of database users and related permissions, so, backing up a database you will automatically include them... you only miss all server's login, and this is the reason you should backup the system databases too...  SignatureAndrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply A backup can work as one option. It depends on what you need it for. You can also script out the database (no data) from Enterprise Manager. Right click on the database, select Generate SQL Script. In the window that comes up for generating the script, you can go to the option tab and select Script Database to script all database settings. You can script Users, Roles and object permissions. On the General tab, you can select the option to script all objects. You have other scripting options from here as well. -Sue >hello, >i m new to sql and i need to export all the settings of a base in sql 2000, >security users ..., is it possible? do i just need to backup the database and >all the settings will be saved? > >THX Hi, thanks for the answer. Now i would like to know if it is possible to generate this script automatically by another script or else? Another option is to use SQL-DMO. You can use the GenerateSQL or Script method to script out a database. There are other options as well. Books online has more information on SQL-DMO and these methods. You can execute the scripts from a job or another application such as VB, C++ -Sue >Hi, thanks for the answer. > >Now i would like to know if it is possible to generate this script >automatically by another script or else? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.