wiki:MS SQL issues

Putting some notes in here that relate to SQL Server specific isssues.

On linux boxes, accessing MS SQL is easiest using 'sqsh' a command-line Transact-SQL client: sqsh -S UHLSQLBRICCSDB
UHLBRICCSDB -U username -P password

On the primary MS SQL server provided by the UHL (UHLSQLBRICCSDB\UHLBRICCSDB), we have configured the following for use by the i2b2 instance on uhlbriccsapp02:

create database i2b2metadata
create database i2b2demodata
create database i2b2workdata
create database i2b2metadata2
create database i2b2demodata2
create database i2b2workdata2
create database i2b2_b1_metadata
create database i2b2_b1_data
create database i2b2_b1_workdata
create database i2b2hive
create database i2b2pm

And the following for use by the uhlbriccsapp03 i2b2:

create database i2b2_app03_metadata
create database i2b2_app03_demodata
create database i2b2_app03_workdata
create database i2b2_app03_metadata2
create database i2b2_app03_demodata2
create database i2b2_app03_workdata2
create database i2b2_app03_b1_metadata
create database i2b2_app03_b1_data
create database i2b2_app03_b1_workdata
create database i2b2_app03_hive
create database i2b2_app03_pm

This is useful on rebuilding indexes: http://www.sqldbpros.com/2010/11/sql-server-rebuild-indexes-the-fastest-way/

Last modified 11 years ago Last modified on 11/01/11 12:07:47
Note: See TracWiki for help on using the wiki.