BSM : migrating SQL Database from standalone to Cluster one (287 Views)
Reply
Regular Advisor
AshishGupta
Posts: 125
Registered: ‎12-06-2010
Message 1 of 4 (287 Views)
Accepted Solution

BSM : migrating SQL Database from standalone to Cluster one

Hi,

 

Curretly we have SQL Database on the standalone database  instance , we would like to migrate it to the cluster environment. DB migration will be owned up by the Database.

 

But from the application(BSM) Side , I would like to undertand what activites need to perform.

 

After the migration , Does DB Connect will suffice or  Do we need to  check the hostname entries in the DB table and perform the cleanup procedure and work like Migration of Database.

 

Any pointers will be really helpful.

 

Regards,

Ashish

Please use plain text.
HP Expert
PatWest
Posts: 831
Registered: ‎03-06-2008
Message 2 of 4 (267 Views)

Re: BSM : migrating SQL Database from standalone to Cluster one

If nothing in the DB's itself have changed, it would be enought to run the BSM Configuration Wizard, and point the new cluster name as the database name.
Please use plain text.
Regular Advisor
AshishGupta
Posts: 125
Registered: ‎12-06-2010
Message 3 of 4 (251 Views)

Re: BSM : migrating SQL Database from standalone to Cluster one

Thanks for your reply Pat, but what I doubt is that There will be change in hostname of the database i.e virtual name of SQL cluster will be given , so don't we need to clean the old entries in the Database ?
Please use plain text.
HP Expert
PatWest
Posts: 831
Registered: ‎03-06-2008
Message 4 of 4 (247 Views)

Re: BSM : migrating SQL Database from standalone to Cluster one

I suggest to check out the following document:

 

http://support.openview.hp.com/selfsolve/document/KM00378713

 

good luck,

Pat

 

 

 

 

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation