move DB to another mssql server

Hi All

   Because I want to mograte windows primary server to ZCM appliance..

but database use MSSQL and it instal at this windows server.

I want to backup and restore to another MSSQL server ..

but when I restore it well...and change configure file in the datamodel folder..

it still fail..

I check the zdm.xml ....it use jdbc/TCP 1999 to connect database..

but I check new database...it dos not open TCP1999...

who has similar experience to provide some information that How could I to do at this time ?

Thanks!!

======================zdm.xml====================

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "">java.sun.com/.../properties.dtd">
<properties>
<comment/>
<entry key="Zone">ZENWORKS_T</entry>
<entry key="MaxInvUIIdleTimeExcessConnections">120</entry>
<entry key="AcquireIncrement">5</entry>
<entry key="MaxPoolSize">100</entry>
<entry key="MinPoolSize">5</entry>
<entry key="MaxIdleTimeExcessConnections">120</entry>
<entry key="MinInvUIPoolSize">5</entry>
<entry key="Type">sql-server</entry>
<entry key="InvUIAcquireIncrement">5</entry>
<entry key="IdleTestPeriod">600</entry>
<entry key="Database">zenworks_ZENWORKS_T</entry>
<entry key="Server">192.168.1.110</entry>
<entry key="MaxIdleTime">3600</entry>
<entry key="Session">com.novell.zenworks.datamodel.session.hibernate.HibernateDataModelSession</entry>
<entry key="Port">1999</entry>
<entry key="MaxInvUIIdleTime">3600</entry>
<entry key="Jdbc_Url">jdbc:sqlserver://192.168.1.110:1999;databaseName=zenworks_ZENWORKS_T;encrypt=false</entry>
<entry key="InvUIIdleTestPeriod">600</entry>
<entry key="Database Directory">c:\database</entry>
<entry key="MaxInvUIPoolSize">100</entry>
</properties>

Wencheng

Tags:

Parents Reply
  • 0 in reply to   

     

       Yes... I compare my prcedure...I lack 2 commands

    ==============

    microfocus-zenworks-configure -c GenerateOSPProperties command

    microfocus-zenworks-configure -c GenerateContentDatasourceConfigureAction

    ================

    But I have another about xml setting..

    default xml file using TCP 1999 connect MSSQL...but tihs port is not common port...so I change to use TCP1433..

    although TCP1433 can be connected, I still want to know how to make the new MSSQL also provide TCP1999 (the same as the original MSSQL)

    thanks!!

    Wencheng

Children