(imported topic written by SystemAdmin)
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
(imported comment written by SystemAdmin)
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.
(imported comment written by SystemAdmin)
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:
Topic
Database Migration (For Remote Database Installations)
But unfortunately i am completely new in this area
Thanks in advance
(imported comment written by PeterLoer)
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
A post was merged into an existing topic: Re-Deploy-BigFix_Platforme_Using the same Licence and same Adresse?