Repository migration Oracle to SQL server

30 views
Skip to first unread message

Erkan

unread,
Jan 20, 2014, 4:09:00 AM1/20/14
to sparx-enterprise-archite...@googlegroups.com
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
[original message]

qwerty

unread,
Jan 20, 2014, 5:09:00 AM1/20/14
to sparx-enterprise-archite...@googlegroups.com
Simply use the Tools/Data Management/Project Transfer option from EA.

q.
[original message]

Erkan

unread,
Jan 20, 2014, 5:22:00 AM1/20/14
to sparx-enterprise-archite...@googlegroups.com
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?

[original message]

Uffe

unread,
Jan 20, 2014, 5:45:00 AM1/20/14
to sparx-enterprise-archite...@googlegroups.com
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.
[original message]

qwerty

unread,
Jan 19, 2014, 7:20:00 PM1/19/14
to sparx-enterprise-archite...@googlegroups.com
Confirmed. Anyway: how much time do you think you could save. 5 seconds? 5 minutes? Time for a coffee?

q.
[original message]

Bellekens@localhost Geert Bellekens

unread,
Jan 19, 2014, 7:35:00 PM1/19/14
to sparx-enterprise-archite...@googlegroups.com
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
[original message]

Erkan

unread,
Jan 21, 2014, 1:34:00 AM1/21/14
to sparx-enterprise-archite...@googlegroups.com
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!
[original message]

Bellekens@localhost Geert Bellekens

unread,
Jan 21, 2014, 1:50:00 AM1/21/14
to sparx-enterprise-archite...@googlegroups.com
Reverse engineering a database is something completely different from transferring a model.

Really completely different.

Geert
[original message]

Erkan

unread,
Feb 5, 2014, 2:58:00 AM2/5/14
to sparx-enterprise-archite...@googlegroups.com
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.
[original message]

qwerty

unread,
Feb 5, 2014, 4:43:00 AM2/5/14
to sparx-enterprise-archite...@googlegroups.com
Consider to clear the audit log before the transfer. That will empty t_snapshot.

q.
[original message]

Utomo@localhost Ferry Utomo

unread,
Feb 12, 2014, 4:50:00 AM2/12/14
to sparx-enterprise-archite...@googlegroups.com
@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.
[original message]

qwerty

unread,
Feb 12, 2014, 4:57:00 AM2/12/14
to sparx-enterprise-archite...@googlegroups.com
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.
[original message]
Reply all
Reply to author
Forward
0 new messages