rCAD Creator Utility

Purpose

Create all Tables, Views, Stored Procedures and Functions for an rCAD Database in a target SQL Server instance.

Populate the Evolutionary Relationships dimension (link) with data from http://www.ncbi.nlm.nih.gov/Taxonomy/.

Note: A single SQL Server instance can host multiple rCAD Databases, as long as different database names are used. If a single SQL Server instance has multiple rCAD Databases, they are considered to be independent, and no cross-referencing is maintained.

Table of Contents

1. Launch the Utility (Back to Top)

  • Shortcut in Start Menu: All Programs\Gutell Lab\rCAD\Utilities: rCAD Instance Creator
rCAD Instance Creator Main Window

2. Identify the SQL Server instance (Back to Top)

  • Enter the name of the SQL Server Instance to install an rCAD database on.
  • Can leave the Instance field blank if targeting the Default instance
  • For SQL Express, enter SQLEXPRESS for the instance name.
rCAD Instance Creator, Set Instance Name

3. Using SQL Express or SQL Server Integration Services not installed? (Back to Top)

  • Check the box to signify this condition.
  • A script will be generated to populate an rCAD database, this script can be executed with the SQLCMD program. See Step 5b below.
rCAD Instance Creator, Using SQL Express Toggle

4. Test the SQL Server Connection (Back to Top)

  • The database connection string is displayed in the Connection String box (A).
  • On a successful connection, the Next (B) option is enabled. Click the Next (B) button to continue.
rCAD Instance Creator, Successful Connection Test

5a. Name and Create the rCAD Database (SQL Server Standard or higher and SSIS installed) (Back to Top)

  • Enter a unique database name and hit the TAB key (A).
  • The list of existing database on the selected instance is provided for reference (B).
rCAD Instance Creator, Specify DB Name SSIS
  • The Create button (A) will be enabled after the TAB key is pressed. Press the Create button (A) to create the database.
  • If the specified database name is already in use, you will be prompted to enter a different database name.
  • Monitor the status line for updates (B). Note: The creation process may take several minutes.
  • Upon successful completion, exit the utility (C).
rCAD Instance Creator, Create DB SSIS

5b. Name and Create the rCAD Database (SQL Express or no SSIS) (Back to Top)

  • Enter a unique database name (A)
  • Identify a script output file for the database install script (B) and press the TAB key.
  • You can use the Browse feature to identify a directory and a target file name. In this example, I want to put the script file on the Desktop (example userid is Test).
rCAD Instance Creator, Create DB no SSIS
  • The Create button (A) will be enabled after a database name and script output file name are provided. Press the Create button (A) to create the database and install script
  • If the specified database name is already in use, you will be prompted to enter a different database name.
  • If the specified script output file exists, you will be notifed to overwrite or provide a different name.
  • Monitor the status line for updates (B). Note: The creation process may take several minutes.
  • Upon successful completion, exit the utility (C).
rCAD Instance Creator, Create DB no SSIS
  • Use the SQLCMD Utility (http://msdn.microsoft.com/en-us/library/ms162773.aspx) to execute the database install script.
  • The command line is > [Program Files]\Microsoft SQL Server\100\Tools\Binn\sqlcmd -S .\[instance name] -i [database install script]
  • This Example: > [Program Files]\Microsoft SQL Server\100\Tools\Binn\sqlcmd -S .\SQLEXPRESS -i C:\Users\Test\Desktop\test.sql
  • Note: If using the default instance for SQL Server Standard or higher the SQLCMD is > [Program Files]\Microsoft SQL Server\100\Tools\Binn\sqlcmd -S . -i C:\Users\Test\Desktop\test.sql

6. Verify rCAD Database Creation (Back to Top)

  • Verify with SQL Server Management Studio that the database has been created.
rCAD Instance Creator, Verify

Last edited Nov 30, 2009 at 7:30 PM by kjdoshi, version 28

Comments

No comments yet.