HPSIM 4 moving database to another SQL server

[Annette Jones_2]

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

[Daniel Leblanc]

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''

[Annette Jones_2]

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?

[Daniel Leblanc]

Is it hard to apply points?

[Annette Jones_2]

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?

[Daniel Leblanc]

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