Before upgrading an existing SQL server database, ensure that the Microsoft sqlcmd utility is executable from a command prompt on this computer. After connecting to the database, issue any TRANSACT-SQL command to ensure that it is working properly.
-
Upgrading an existing SQL Server database does not drop existing set up conditions or recreate the database; the upgrade deploys the database constructs on top of the existing database setup.
-
Only Microsoft SQL Server database administrators or equivalent should perform any function described in this section.
Before upgrading an existing database, we strongly recommend backing up the existing database and keeping a copy of the back-up in a safe place.
See the following syntax when executing the Microsoft sqlcmd utility. For more information, see the Microsoft SQL Server documentation.
|
usage: sqlcmd |
[-U login id] |
[-P password] |
|
[-S server] |
[-H hostname] |
[-E trusted connection] |
|
[-d use database name] |
[-l login timeout] |
[-t query timeout] |
|
[-h headers] |
[-s colseparator] |
[-w columnwidth] |
|
[-a packetsize] |
[-e echo input] |
[-I Enable Quoted Identifiers] |
|
[-L list servers] |
[-c cmdend] |
[-D ODBC DSN name] |
|
[-q "cmdline query"] |
[-Q "cmdline query" and exit] |
[-n remove numbering] |
|
[-m errorlevel] |
[-r msgs to stderr] |
[-V severitylevel] |
|
[-i inputfile] |
||
|
[-p print statistics] |
[-o outputfile] |
|
|
[-O use Old ISQL behavior disables the following] |
[-b On error batch abort] |
|
|
<EOF> batch processing Auto console width scaling Wide messages default errorlevel is -1 vs 1 |
||
|
[-? show syntax summary] |
-
Insert the HxGN EAM SQL Server Database Installation CD into the proper drive.
-
Locate and right-click the Setupwin32.exe file, and Run as administrator.
If you are installing from a drive other than D:, substitute that drive for D: in
these instructions.
-
Select a language to use, and then click OK.
By selecting a language, you are selecting a language to be used during the installation,
not a language to be used by the SQL Server database.
-
Click Next.
-
Enter the CD Key for the product, and click Next.
-
Select I accept the terms of the license agreement if you agree to the terms, and click Next.
-
Select to upgrade an existing database.
-
Click Next.
-
Ensure that your computer meets all installation requirements, and then click Next.
-
Specify the directory for database installation processing (the logs and all scripts are created in this directory), and then click Next.
All database configuration scripts and installation logs are created and processed
in the chosen directory.
-
Specify this information:
Host Name - Specify the name of the server on which Microsoft SQL Server is installed.
Instance Name - Specify the name of the database instance, if any.
If your server does not have specific instances installed, you do not have to enter
a value for Instance.
Listener Port - Specify the Microsoft SQL Server listener port.
System Administrator User - Specify the system administrator user name of the account that you will use to create the database.
System Administrator Password - Specify the system administrator password of the account that you will use to create the database.
We strongly recommend that only SQL Server database administrators or equivalent
with accesses to create and configure databases, create users, and grant privileges
install and configure the SQL Server database.
-
Click Next.
-
Specify this information:
Login - Specify the database login that you use to connect to the EAM application.
We strongly recommend that you enter the Login and Password that you currently use to connect to EAM.
Password - Specify the database password that you will use to connect to the EAM application.
The Login and Password that you entered are used for validation to connect to the database; it does not alter
the server level security, replication, or back up settings.
Database - Specify the name of the database that is currently being used for the EAM application.
To upgrade, you must enter an existing EAM database name for Database.
-
Click Next.
-
Specify the path to the Binn directory for your Microsoft SQL Server instance. Extended stored procedure .dll and .xml files are copied to this directory.
If you are installing the SQL Server database from a machine that is not the server:
-
You must map to the Binn directory where SQL Server is installed. For example, if your target MS SQL Server is installed at C:\Program Files\Microsoft SQL Server, then map the drive C:\Program Files\Microsoft SQL Server\MSSQL$<Instance> and enter the input as <Mapped Drive>\Binn.
-
You (the Windows user logged on for the Installation) must have write permission for that directory.
-
If the HxGN EAM application connects to the target SQL Server, you must stop the application server services. The Auto-Installation must update files that are used by the application servers during the SQL Server database installation.
-
If your SQL Server engine is 64-bit, your remote server must be 64-bit as well.
-
-
Click Next.
If applicable, Enter a CD key for the Mobile user license (optional), Enter a CD key for the Connector user license (optional), Enter a CD key for the Barcoding user license (optional), and Enter a CD key for the Requestor user license (optional) values are automatically populated.
-
Specify a CD key for the Mobile user license (optional) if you have purchased a license for Mobile.
-
Specify a CD key for the Connector user license (optional) if you have purchased a license for Connector.
-
Specify a CD key for the Barcoding user license (optional) if you have purchased a license for Barcoding.
-
Specify a CD key for the Requestor user license (optional) if you have purchased a license for Requestor.
-
Click Next. A message is displayed asking whether you choose to run the database scripts manually or to have the system create and automatically run the database scripts.
-
Click Yes to create and automatically run the database scripts, or click No to run the installation database scripts manually. If you click Yes, the system creates and runs the database scripts and displays the final installation dialog box. If you click No, the system creates the database scripts, but you must run the scripts manually.
Once the system begins to create the scripts, we strongly recommend that you do not
cancel the installation.
-
Click Finish.
If you selected for the system to automatically run the database scripts, examine
the log files in the log directory you created earlier in this section for errors.