Topic
  • 3 replies
  • Latest Post - ‏2013-02-27T20:00:10Z by PeterLoer
SystemAdmin
SystemAdmin
2038 Posts

Pinned topic Migrate from SQL Express to SQL Standard

‏2013-02-01T09:15:03Z |
I have searched the forums but there doesnt seem to be a clear cut answer so I wonder if you could help.

Due to licensing issues amongst others, we had to setup IEM using SQL Express however we have just been given access to a proper SQL license.

My question is how does one migrate everything to SQL from SQL Express, then tell IEM to work from it?

IEM is very new to me so your help is much appreciated.

Thanks
  • SystemAdmin
    SystemAdmin
    2038 Posts

    Re: Migrate from SQL Express to SQL Standard

    ‏2013-02-05T00:32:51Z  
    SQL Express is intended to be used for evaluation installs only (because of limitations in the SQL Express version: http://www-01.ibm.com/support/docview.wss?uid=swg21505824). Also see server requirements (http://www-01.ibm.com/support/docview.wss?uid=swg21505691) and SQL Server licensing necessary for TEM server (http://www-01.ibm.com/support/docview.wss?uid=swg21505975).

    After the evaluation is over, it is expected that the customer install the production version of the application on a new database instance on SQL Server 2003/2008/2008R2 Standard/Enterprise.

    As such, there is currently no supported migration path for migrating data from a SQL Express database to a production supported MS SQL database. You may want to contact Support for more information regarding this.
  • SystemAdmin
    SystemAdmin
    2038 Posts

    Re: Migrate from SQL Express to SQL Standard

    ‏2013-02-27T12:23:09Z  
    Is there really no way for this scenario. We are also planing to migrate from the evaluation database directly to the SQL Standard Database.
    Any help about this would be highly appreciated!

    The only thing i found:

    https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en#/wiki/Tivoli%20Endpoint%20Manager/page/Server%20Migration

    Topic
    Database Migration (For Remote Database Installations)

    But unfortunately i am completely new in this area
    Thanks in advance
  • PeterLoer
    PeterLoer
    19 Posts

    Re: Migrate from SQL Express to SQL Standard

    ‏2013-02-27T20:00:10Z  
    Is there really no way for this scenario. We are also planing to migrate from the evaluation database directly to the SQL Standard Database.
    Any help about this would be highly appreciated!

    The only thing i found:

    https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en#/wiki/Tivoli%20Endpoint%20Manager/page/Server%20Migration

    Topic
    Database Migration (For Remote Database Installations)

    But unfortunately i am completely new in this area
    Thanks in advance
    Hi Stefan,

    It may not be the official supported path, probably because there aren't any tools or guides to check that everything has gone correctly during the migration, but it is definitely doable.

    Basically, as long as you can install the full version and make sure it picks up the database contents, existing user roles, etc. from the express version, and is available at the same location, it will work (and in fact IEM won't even know the difference).

    I believe all recent versions of SQL server have an 'inplace edition upgrade' installation path which is what you will want; for instance, here is a URL with some documentation from microsoft on the pathway in SQL Server 2012: http://msdn.microsoft.com/en-us/library/cc707783.aspx.

    If you have an environment you can experiment in, maybe you can just take a backup and try it out. If you do the upgrade and everything seems to work and all of your operators are able to connect, you should be good.

    cheers,

    peter