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.
This topic has been locked.
3 replies Latest Post - 2013-02-27T20:00:10Z by PeterLoer
Pinned topic Migrate from SQL Express to SQL Standard
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-27T20:00:10Z at 2013-02-27T20:00:10Z by PeterLoer
Re: Migrate from SQL Express to SQL Standard2013-02-05T00:32:51Z in response to SystemAdminSQL 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.
Re: Migrate from SQL Express to SQL Standard2013-02-27T12:23:09Z in response to SystemAdminIs 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:
Database Migration (For Remote Database Installations)
But unfortunately i am completely new in this area
Thanks in advance
PeterLoer 270004AXT219 PostsACCEPTED ANSWER
Re: Migrate from SQL Express to SQL Standard2013-02-27T20:00:10Z in response to SystemAdminHi 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.