Hive uses a relational database to store metadata. This section assumes that you used SQL Server to store Hive metadata.
To upgrade an existing MS SQL database for Hive run the
%HIVE_HOME%\scripts\metastore\upgrade\mssql\hive-txn-schema-0.13.0.mssql.sql
on the Microsoft SQL server that contains the Hive database instance.
![[Note]](../common/images/admon/note.png) | Note |
|---|---|
If you used the Derby database option, you can skip this section. |
If you use a new database name and set up new users, then you must add this new
information into the clusterproperties.txt file used to upgrade to
HDP 2.1.
