November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Converting database from Oracle to SQL server
Vote:
Hello, has anyone successfully moved an EPiServer database (4.6x or 5.x) from Oracle to SQL Server? Did you use SQL Server Migration Assistant? Any other experience of this tool? I thought there was an EPiServer article about this (for 4.62), but I can't find it now.
Aug 21, 2009 11:17
I suggest you use EPiServer export functionality on the Oracle site and import on the Sql Server site. Then you will miss:
#32109
- 1) History of all pages
- 2) A few things stored in Object store like data from EPiServer Statistics, WSRP and mirroring functionality.
- 3) And probable some other small things
But I think that this is the easiest way to do a migration.
Aug 22, 2009 12:08
Hi,
We have succesfully moved from Oracle to MS SQL with the use of a SSIS package.
This way we kept all PageIDs(not using FURL), mirroring info etc.
Our Oracle database was case sensitive and we did go with a case insesitive MS SQL implementation so we ended up with a little cleaning up, nothing major. Mostly in the tblSID table with users haveing registed them selves with ABBA@se.se and abba@se.se, as an example :-)
We had to translate the GUIDS from being stored as strings in Oracle to genuine GUIDS in MSSQL, and some other minor translations.
It went supprisingly smooth, all handled in a SSIS package, takes about 10min to pump data from Oracle to MS SQL with 40 000 pages + pageversions.
So it can be done :-)
Regards,
Morten
Oct 23, 2009 15:15
