Install SQL SERVER and create a database - database configuration/design
tasks
If you are tasked with installing and configuring the
database, here is a list of steps to be taken:
Install the Microsoft™ SQL
SERVER on your computer.
Important:Make sure that you select the correct collation when installing SQL
Server: The default collation will apply to the tempdb database and will also be used for
temporary tables, instead of inheriting the collation of the current database. If the default
server collation does not match the collation of the current database, you will experience
character set conflicts between permanent tables and temporary tables (SQL Server error
message 468).
Create a SQL SERVER database entity with the SQL
SERVER Management Studio. In the database properties:
Choose the right code page / collation to get
a case-sensitive database; this cannot be changed later. Remember
collation defines the character set for CHAR/VARCHAR columns, while
NCHAR/NVARCHAR columns are always storing UNICODE (UCS-2) characters. Informix® collation order is
codeset based for CHAR/VARCHAR/TEXT columns. If you want to get the
same sort order with SQL Server, you will need to use a binary collation
such as Latin1_General_BIN.
Make sure the "ANSI NULL Default" option is TRUE if
you want to have the same default NULL constraint as in Informix (i.e. a column created without
a NULL constraint will allow null values, users must specify NOT NULL
to deny nulls).
Make sure the "Quoted Identifiers Enabled" option
is FALSE to use database object names without quotes as in Informix.
Create and declare a database user dedicated to your application:
the application administrator .
If you plan to use SERIAL emulation based on triggers using
a registration table, create the SERIALREG table and create the serial
triggers for all tables using a SERIAL. See SERIAL data types.
Create the application tables . Do not
forget to convert Informix data
types to SQL SERVER data types. See Data type conversion table. In order
to make application tables visible to all users, make sure that the
tables are created with the 'dbo' owner.