SC-Scripter 1.0 Copyright (C) 1994 SplitCycle Computing - All Rights Reserved This file contains the following sections: * Overview * System requirements * Installation * Command line parameters * Command summary * Support and questions ======== O V E R V I E W ================================================= SC-Scripter is a fast and easy SQL Server management assistant that can increase developer and database administrator productivity. It will generate Transact-SQL scripts for entire databases or individual objects. It's command line interface allows database definitions to be generated as part of your complete backup procedures. This program can be a valuable tool in moving, restoring and examining databases. SC-Scripter is distributed as Shareware. This means that users are encouraged, subject to restrictions described in the License Agreement, to share copies of this program with friends, associates and bulletin boards. Please remember that if you use this software you are required to pay the registration fee of $39 as described in files LICENSE.TXT and ORDER.TXT. This program is produced by a member of the Association of Shareware Professionals (ASP). ASP wants to make sure that the shareware principle works for you. If you are unable to resolve a shareware-related problem with an ASP member by contacting the member directly, ASP may be able to help. The ASP Ombudsman can help you resolve a dispute or problem with an ASP member, but does not provide technical support for members' products. Please write to the ASP Ombudsman at 545 Grover Road, Muskegon, MI 49442 or send a CompuServe message via easyplex to ASP Ombudsman 70007,3536. _______ ____|__ | (R) --| | |------------------- | ____|__ | Association of | | |_| Shareware |__| o | Professionals -----| | |--------------------- |___|___| MEMBER ======== S Y S T E M R E Q U I R E M E N T S =========================== - Operating system should be one of the following * DOS 4.0 or above * Microsoft Windows NT 3.1 or above * IBM OS/2 2.1 or above - Network or local access to a Microsoft/Sybase SQL Server version 4.2 or above - Netlib from Microsoft or Sybase for DOS version 4.21 or above - SC-Scripter should work if ISQL (MS/Sybase utility) works. ======== I N S T A L L A T I O N ========================================= 1) If you already have installed a previous version of SC-Scripter, backup and delete all files in your SCSCRIPT directory. Otherwise create a directory to hold the SC-Scripter related files. Example: C:\SCSCRIPT 2) Copy all SC-Scripter related files to this directory. At a minimum you need SCSCRIPT.EXE 3) Add "C:\SCSCRIPT" to your PATH in your AUTOEXEC.BAT file, if you plan on using SC-Scripter frequently. 4) Run SCSCRIPT.EXE (passing any necessary command line parameters). Example: SCSCRIPT -Usa -P <--- assuming C:\SCSCRIPT is in your PATH or that you are currently in its directory. ======== C O M M A N D L I N E P A R A M E T E R S =================== Syntax: SCScript [-U login id] [-P password] [-S server] [-D database] [-Q "command line query"] [-I inputfile] [-O outputfile] [-? show syntax summary] Where -U login id is the user login ID (case sensitive) -P password is the user login's password (case sensitive). SC-Scripter will prompt for a password if -P is not passed (password not echoed). -S server specifies the SQL Server that you wish to connect to (case sensitive) -D database name of database that the connection should initially be made to -Q "command line query" executes the specified command and then exist SC-Scripter -I inputfile name of file containing a batch of SC-Scripter commands -O outputfile name of file to be default destination for any created scripts -? show syntax summary lists the available command line parameters ======== C O M M A N D S U M M A R Y =================================== The following commands are available: CREATE DEPENDS EXIT HELP LIST QUIT USE "CREATE" Generate a database object definition script file. syntax: CREATE objectname outputfile objectname - Name of object for which a script is to be generated or keyword "ALL". Wild character "%" is allowed. outputfile - Any valid filename to be used for script output. examples (assuming your in the pubs database): CREATE titles creates a script file for object "titles". The script is written to the outputfile specified on the command line or to "titles.sql" as a default. CREATE rep% miscrep.sql creates a script file for objects with names starting with "rep". All output is written to file "miscrep.sql". CREATE ALL creates a script file for all objects in the current database. The script is written to the outputfile specified on the command line or to "pubs.sql". "DEPENDS" Generate database object definitions for all objects that are dependent on a specified table. syntax: DEPENDS tablename outputfile tablename - Name of user table in current database. outputfile - Any valid filename to be used for script output. example: DEPENDS titles titles.dep creates a script file for all dependencies of table "titles", output is written to "titles.dep". "EXIT" Exits the program. syntax: EXIT "HELP" Displays list of available commands and short description. syntax: HELP "LIST" List object names that match a specified search criteria. syntax: LIST objectname objectname - Character string used in matching object names in the current database. Wild character "%" is allowed. example: LIST rep% list objects with names starting with "rep". "QUIT" Exits the program. syntax: QUIT "USE" Switches the database context to a specified database. syntax: USE database_name database_name - valid database name in the current server. example: USE pubs swith database context to "pubs". ======== S U P P O R T A N D Q U E S T I O N S ======================= Technical support is available at no charge by sending electronic mail to 73501,1261 on CompuServe, or by sending US Mail to SplitCycle Computing, 13102 Rivergate Lane, Jacksonville, FL 32223. Registered users have priority but I will try to answer all questions. When reporting problems with SC-Scripter, please include the following information: 1) Can the problem be recreated? If so, how? 2) What operating environment did this occur in? Please specify version of DOS, NT or OS/2. 3) If an error message was displayed, please include the text of the message. Suggestions for enhancements are welcome from all users. A Windows version is being worked on and features specific to System 10 will be added shortly. ======== E N D O F D O C U M E N T ===================================