Changes between Version 11 and Version 12 of i2b2 HowTo Create a Project

Timestamp:

05/12/16 12:07:27 (8 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create a Project

@@ -9 +9 @@
 === 1. Create Databases
 
-Run the following SQL script.  Change [!ProjectName] to be the actual project name:
+Run the following SQL script found in the SVN repository [[https://svn.rcs.le.ac.uk/LCBRU/i2b2/i2b2/trunk/SqlScripts/]].
 
-  {{{
-  #!sql
-CREATE DATABASE [ProjectName]_MetaData
-GO
-CREATE DATABASE [ProjectName]_Data
-GO
-CREATE DATABASE [ProjectName]_WorkData
-GO
-
-CREATE LOGIN [ProjectName]_MetaData WITH PASSWORD = '[ProjectName]_MetaData';
-GO
-CREATE LOGIN [ProjectName]_Data WITH PASSWORD = '[ProjectName]_Data';
-GO
-CREATE LOGIN [ProjectName]_WorkData WITH PASSWORD = '[ProjectName]_WorkData';
-GO
-
-USE [ProjectName]_MetaData
-CREATE USER [ProjectName]_MetaData FOR LOGIN [ProjectName]_MetaData
-GO
-EXEC sp_addrolemember N'db_owner', N'[ProjectName]_MetaData'
-GO
-
-USE [ProjectName]_Data
-CREATE USER [ProjectName]_Data FOR LOGIN [ProjectName]_Data
-GO
-EXEC sp_addrolemember N'db_owner', N'[ProjectName]_Data'
-GO
-
-USE [ProjectName]_WorkData
-CREATE USER [ProjectName]_WorkData FOR LOGIN [ProjectName]_WorkData
-GO
-EXEC sp_addrolemember N'db_owner', N'[ProjectName]_WorkData'
-GO
-
-  }}}
-
-
-=== 1a. Create Bespoke Data Import Stored Procedures
-
-Create the bespoke data import stored procedures by copying them from another project:
-
-* INSERT_EID_MAP_FROMTEMP_RB
-* INSERT_PATIENT_FROMTEMP_RB
-* INSERT_PID_MAP_FROMTEMP_RB
-* CREATE_TEMP_TABLE
-
+Before running you will need to use Find and Replace to replace the string `{Study Name}` with the name of the study.
 
 === 2. Edit Project Creation Config and Scripts