Author Topic: Repository migration Oracle to SQL server (Read 7157 times)

Erkan · « **on:** January 20, 2014, 08:09:38 pm »

Dear reader,

We would like to migrate our repository from Oracle 9.2 to a SQL sever 2008 database. What steps do you recommend?

Thanks, Erkan

qwerty · « **Reply #1 on:** January 20, 2014, 09:09:04 pm »

Simply use the Tools/Data Management/Project Transfer option from EA.

q.

Erkan · « **Reply #2 on:** January 20, 2014, 09:22:44 pm »

Thanks for your reply. I wonder if this would be a fast option? Would it not be faster to do a database script from database to database?

Uffe · « **Reply #3 on:** January 20, 2014, 09:45:32 pm »

I'd rather go with Sparx's option than a third-party tool.
It might not be the fastest, but it's probably the safer bet since EA's transfer function presumably knows about any "smart" solutions employed in any particular database engine and can make sure everything gets moved the way it's supposed to.

qwerty · « **Reply #4 on:** January 20, 2014, 11:20:21 pm »

Confirmed. Anyway: how much time do you think you could save. 5 seconds? 5 minutes? Time for a coffee?

q.

Geert Bellekens · « **Reply #5 on:** January 20, 2014, 11:35:05 pm »

In fact the Project transfer is not much more then a (Sparx tested and approved) database script that transfers the data from one DB to another.

On our (very large) Model the transfer takes about 30 minutes to an hour.

Geert

Erkan · « **Reply #6 on:** January 21, 2014, 05:34:52 pm »

Ok that is good news. My experience with importing large databases with hundreds of tables without data (reversed engineering) can take up to 6 hours!

Geert Bellekens · « **Reply #7 on:** January 21, 2014, 05:50:50 pm »

Reverse engineering a database is something completely different from transferring a model.

Really completely different.

Geert

Erkan · « **Reply #8 on:** February 05, 2014, 06:58:38 pm »

Yesterday I tried to migrate from oracle to SQL server (test environment). Our repository is 2.5 GB, but it took over 4 hours and then the process crashed at table T_Snapshots. The log does not show what reason. I am trying it again today.

qwerty · « **Reply #9 on:** February 05, 2014, 08:43:39 pm »

Consider to clear the audit log before the transfer. That will empty t_snapshot.

q.

Ferry Utomo · « **Reply #10 on:** February 12, 2014, 08:50:55 pm »

@erkan @querty
Do you experience any performance differences between Oracle and SQL Server? Does Oracle better than SQL Server or otherwise or not much difference? I'm considering to migrate from Oracle to SQL Server as well.

qwerty · « **Reply #11 on:** February 12, 2014, 08:57:09 pm »

You should take that repository where you got the better admins. The SW isn't that crucial. It's the guys which can tune the system.

q.

Sparx Systems Forum

News: