topic HPSIM 4 moving database to another SQL server in Server Management - Systems Insight Manager

HPSIM 4 moving database to another SQL server

Annette Jones_2 — Thu, 26 Apr 2007 07:10:40 GMT

Just wanted advice on moving SQL database, the database.props file is listed below:

Do I have to change just the .hostname, there is no .instance parameter but should there be one?

Regards
A

--- Database Manager Properties ---
#Tue Jan 11 09:09:51 GMT 2005
hp.Database.schemaUpgradeFile_1=schema40_41.sql
hp.Database.portNumber=1433
hp.Database.databaseName=Insight_v1_0_12252390
hp.Database.schemaFileNamePrefix=hp.Database.schemaFile_
hp.Database.dsn=Insight_v1_0
hp.Database.jdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver
hp.Database.hostName=127.0.0.1
hp.Database.authType=host
hp.Database.schemaUpgradeFile=1
hp.Database.schemaFileCount=3
MxVersionNumber=C.04.01.00.00%20040902
hp.Database.charSet.ja=MS932
hp.Database.jdbcUrlPrefix=jdbc\:odbc\:Insight_v1_0
hp.Database.password=
hp.Database.adminDB=master
hp.Database.charSet.en=UTF-8
hp.Database.sqlSchema=
hp.Database.vHandler=com.hp.mx.database.MsSqlVerificationHandler
hp.Database.schemaFile_3=schema40_41.sql
hp.Database.charSet.??=UTF-8
hp.Database.schemaFile_2=DCSchema10.sql
hp.Database.schemaFile_1=schema40.sql
hp.Database.username=sa
hp.Database.adminUser=sa
hp.Database.schemaUpgradeFilePrefix=hp.Database.schemaUpgradeFile_
hp.Database.schemaUser=sa

Re: HPSIM 4 moving database to another SQL server

Daniel Leblanc — Thu, 26 Apr 2007 08:24:21 GMT

This document will help you:
http://h10018.www1.hp.com/wwsolutions/misc/hpsim-helpfiles/hpsim_5_migratingNewSystem.pdf

DOn't forgot to apply you're points, it next to date and time of the message, now it ''UNASSIGNED''

Re: HPSIM 4 moving database to another SQL server

Annette Jones_2 — Thu, 26 Apr 2007 08:35:18 GMT

Daniel,

This document only assumes to move a local MSDE database to SQL server, I want to move a database from an old SQL server to a new SQL server.

Are they any specific instructions around this?

Re: HPSIM 4 moving database to another SQL server

Daniel Leblanc — Thu, 26 Apr 2007 08:39:05 GMT

Is it hard to apply points?

Re: HPSIM 4 moving database to another SQL server

Annette Jones_2 — Thu, 26 Apr 2007 08:58:43 GMT

Daniel,

I was going to apply points once I had got the answer I was looking, I already have this documentation, but wanted to ensure there were no specific instructions with HPSIM4 and moving databases between SQL servers, rather than MSDE databases!!!!!

Are the points that precious that a simple thank you very much for you help, won't do?

Re: HPSIM 4 moving database to another SQL server

Daniel Leblanc — Thu, 26 Apr 2007 09:27:16 GMT

1-3: The answer didn't help answer my question, but thanks anyhow!
4-7: The answer helped with a portion of my question, but I still need help.
8-10: The answer has solved my problem completely! I'm a happy camper!

WHY SHOULD YOU DO THIS?
There are 3 reasons why we feel rating replies is such an important feature:

1.) Others have taken time to help you, so please give them credit for their help.
2.) Your rating will help your peers earn points toward their Forums status, and you will validate the quality of the solution you've received.
3.) Other readers will understand which answer best solved a problem, enriching the community knowledge being shared.
---------------------------------------
To move database SQL to SQL :
http://support.microsoft.com/kb/224071/en-us

DOnt forget to apply the modification from one server HP sim for the name on page 6