Want to get rid of Google Ads, click here.
+ Reply to Thread
Results 1 to 7 of 7

Thread: Upgrade 7.00 to 7.01

  1. 2008-02-28 #1
    tommy
    tommy is offline
    Administrator tommy's Avatar
    Join Date
    Nov 2001
    Location
    Copenhagen
    Posts
    4,272

    Default Upgrade 7.00 to 7.01

    Ok so I want to upgrade. Binaries is of course no problem but I also want to get the database refreshed just to start from a fresh database.

    I only have MS SQL Express 2005 installed and have no knowlegde about it. I just know that when I came to the point of uploading data it failed of course because the database already existed ( I knew there were 99.999% change that would happen but had hoped HP had included an optin to delete the database).

    So how do I delete the SM7_DEMO database and create a new empty ?
    Best regards Tommy
    Blog - - ITIL certified - Accredited Integration Specialist – HP OpenView Service Management

    Want to keep this site alive? Consider making a donation. Click here.
    Reply With Quote Reply With Quote
  2. 2008-02-29 #2
    benvargas
    benvargas is offline
    Senior Member benvargas's Avatar
    Join Date
    Apr 2005
    Location
    San Diego, CA USA
    Posts
    194

    Default

    I'm not a DBA and it's been since late November since the initial install, but when I couldn't run the out of box SQL database installer from the CD I installed SQL Server Express and created a new database and user using this GUI tool:

    http://www.microsoft.com/downloads/d...displaylang=en

    Apparently SQL Server Express doesn't come with a GUI management tool. If all you have is the SQL Server 2005 Express database and no GUI then this might be all the help you need.

    Once I installed SM I then used the GUI management tool to backup the database. Now it is very easy to just restore the database through the GUI management tool whenever I need to go back to an OOB system.
    Reply With Quote Reply With Quote
  3. 2008-02-29 #3
    tommy
    tommy is offline
    Administrator tommy's Avatar
    Join Date
    Nov 2001
    Location
    Copenhagen
    Posts
    4,272

    Default

    Ok I will try that.

    I actually ended up with uninstalling and deleting the old data then reinstalling.
    Best regards Tommy
    Blog - - ITIL certified - Accredited Integration Specialist – HP OpenView Service Management

    Want to keep this site alive? Consider making a donation. Click here.
    Reply With Quote Reply With Quote
  4. 2008-03-01 #4
    Artur
    Artur is offline
    Senior Member
    Join Date
    Apr 2006
    Location
    Poland
    Posts
    680

    Default

    Hi,

    you may download a trial version of MS SQL 2005 - this will give you the gui tools
    for admin as well. It workd for me - I had to install the demo database manually because somehow the scripts did not worked at all.

    regards
    Artur
    Reply With Quote Reply With Quote
  5. 2008-03-01 #5
    jstagaman
    jstagaman is offline
    Senior Member
    Join Date
    Jul 2006
    Location
    San Francisco, CA
    Posts
    172

    Default Instructions for setting up a database

    The attached instuctions for installing SM7 include a walkthrough of configuring the SM7 database manually rather than using the batch file to create SM7DEMO.
    Attached Files
    Reply With Quote Reply With Quote
  6. 2008-03-03 #6
    chergenroether
    chergenroether is offline
    Junior Member
    Join Date
    Oct 2002
    Location
    Germany
    Posts
    7

    Default

    You could have also edited the SQL Install Batch file and delete the entries to install dot.NET and SQL-Server. Then just delete the demo database and start the Batch-file again.

    This should have also done the job.

    For administrating the SQL-Server I would recommend to install the SQL Server Management Studio Express, you can find this one here:
    http://msdn2.microsoft.com/en-us/express/bb410792.aspx

    A nice and easy way to look at the SQL-data is SQLBrowser (Freeware):
    http://www.kgo.de/SQLBrowser.html

    HTH
    Last edited by chergenroether; 2008-03-05 at 10:31.
    Best Regards...
    Carsten
    Reply With Quote Reply With Quote
  7. 2008-03-05 #7
    tommy
    tommy is offline
    Administrator tommy's Avatar
    Join Date
    Nov 2001
    Location
    Copenhagen
    Posts
    4,272

    Default

    Quote Originally Posted by chergenroether View Post
    You could have also edited the SQL Install Batch file and delete the entries to install dot.NET and SQL-Server. Then just delete the demo database and start the Batch-file again.

    This should have also done the job.
    Yes I did go about that route however the highlighted part was what I needed to do but did not know hot to do it without a gui.
    Best regards Tommy
    Blog - - ITIL certified - Accredited Integration Specialist – HP OpenView Service Management

    Want to keep this site alive? Consider making a donation. Click here.
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules