Upgrading to SQL 2005

Discussion in 'H-Sphere Shared Hosting' started by Mycroft, Sep 24, 2009.

  1. Mycroft

    Mycroft Perch

    Hi,

    I just opened a ticket to upgrade my database from SQL 2000 to SQL 2005. I was told that it can't be done for existing accounts and I'll have to sign up for a new account if I want 2005. Is thisx true? I've been a customer for several years. I do not want to sign up for another account.

    Regards,

    -Jim
  2. Stephen

    Stephen US Operations Staff Member

    Sadly there is no mechanism built into hsphere to allow SQL server changes like this(MySQL or MSSQL) It isn't a limit we like, but not something we can change :(
  3. Mycroft

    Mycroft Perch

    So I'm stuck with SQL 2000 forever? I don't even think it's supported anymore.
  4. Stephen

    Stephen US Operations Staff Member

    I will discuss with sales some options for this but need 24.-48 hours time.
  5. Mycroft

    Mycroft Perch

    Ok thanks.
  6. Stephen

    Stephen US Operations Staff Member

    ok as an update here:

    within 48 hours we are making a special internal account for handling issues like this on cluster1
    the workaround will be for us to have a managed sql 2005 account for this, and we can then create a DB for you, and give you login rights and SQL view permissions.
    it is not perfect I will freely admit, as it doesn't allow you to edit it yourself, but it will allow you to have SQL 2005 DB and allow us to have management interface to reach it(not doing 100% manually and leaving behind pieces like we have done a few times in past)

    Will this work for you? That will mean you still have SQL 2000 within your CP, which you can use if you wish, and SQL 2005 can be made with a ticket and we will reply back with the login info on it.
  7. Mycroft

    Mycroft Perch

    Will my login have owner rights on the database you create for me? I will need to be able to create tables, stored procedures etc.

    If that's the case it sounds like a acceptable solution.

    Thanks for your help on this.
  8. Stephen

    Stephen US Operations Staff Member

    Indeed it will :)
  9. Mycroft

    Mycroft Perch

    That's great. Thanks again for your help on this.

    Can you do me one last favor? Would you please let me know when you have the ability to do this set up so that I can open the ticket?

    Regards,

    -Jim
  10. Stephen

    Stephen US Operations Staff Member

    Yes. I am going to update this topic again when it is done. I am working on making it today, but need to get a little rest first, been a long night, and just learned all my family has the flu(which means I have no desire to visit them now), so weekend plans off now too. I have plenty time for work! :)
  11. Mycroft

    Mycroft Perch

    LOL. Well don't rush on account of me. Rest and have yourself a nice weekend. You don't want to get yourself sick too. This is by no means an urgent request.
  12. Stephen

    Stephen US Operations Staff Member

    It needs to be done, no need for it to delay :)
  13. Mycroft

    Mycroft Perch

    Any word on this?
  14. Stephen

    Stephen US Operations Staff Member

    Mail to sales with a CC to support and it will be setup within 24 hours, the reason for sales is basically for accounting they wanted me to specify this one thing:
    As long as you have available DBs it will be free, if it is extra DBs it will be $2 each + looking at your available disk space for extra(but if you have free DBs and free space, there is no issue)
  15. Mycroft

    Mycroft Perch

    Thanks. The only issue I see is that I'm currently using my one available DB. Once the new DB is set up I'd be transfering the data to the new database and I could delete the current one.
  16. Stephen

    Stephen US Operations Staff Member

    No problem, we'll let you do that :)
  17. Mycroft

    Mycroft Perch

    Stephen,

    I wanted to thank you for taking care of this for me. I opened the ticket and the database was created for me quickly and I'm now up and running on SQL 2005. Attention to issues, no matter how small the issue or customer, is one of the reasons I'm still with Jodohost after 6 years.

    Regards,

    -Jim

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services