Welcome Guest, you are in: <root>iCISPTC • Login

Page History: Client Database Utility Scripts

Compare Page Revisions

10 9 8 7 6 5 4 3 2 1 0 Current 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 12/07/2013 11:19

Client Database Utility Scripts and Procedures¶

Database»Client Database Utility Scripts

1. Backup and restore client security settings
   1. How to get the script: (this link will only work from in the imsoftech domain so that only SupportTechs and Developers can access it: w2k3-dev1 Phoenix ICIS Guidance - UilityScripts - 'util - iCIS - copy security settings.sql'
   2. When to use this script
      • Use this script to backup client security settings before rebuilding the security setup data for the version of iCIS being used. You can use the output this script to later restore the security setting
   3. How to use this script
      • For this script to work in SQL Server Management Studio the default max number of characters to display for each column must be increased. You need bring up the options dialog using the tools menu (Tools->Options…)
        • Expand “Query Results”
        • Expand “SQL Server”
        • Select “Results to text” (that refers to the highlighted button in the image below. You need to have it selected as shown too)
        • Change max characters… from 256 or whatever it is to something big like 2000
          
          
          
          When you’re ready to save off the permissions run the script and save the text in the results window to a script file.
          
          When you’re ready to restore the permissions run that script file.