Convert Oracle Model to SQL Server in SparxSystems EA
Using SparxSystems EA, convert an Oracle data model in a SQL Server data model and produce a DDL script
Closed Caption:
this video shows how to create a single
server data model from
Oracle Data Model using spark systems at
a price
architect Enterprise Architect supports
more than just Oracle
in sequel server post-crescent my sequel
are included in this procedure will work
for any pairing up databases
have started with a contact able in
address table
the contact able is parrot such that it
contacted have many
addresses in that relationship is
enforced in the foreign key
in order to convert this to sequel
server
I coach my project browser in the Oracle
Data Model
I copied the elements to clipboard
select a package that i'm associating
with my sequel server data model
right click and select paste elements
from clipboard then a drag them onto the
campus music control cue to Ben
but a break in the lines sticking format
this display little bit better
now
in order to convert this to a sequel
surfer table
it's known Oracle table just in a
different location it all
enter it brings up my Properties panel
when I select
single server 2008 and you'll notice
that the tapes to see also protects now
do the same with mattress table take
conversion wasn't quite perfect because
whatever
really wanna might on model
for single server is that like my
identity columns
to be a.m. take in retina decibel
Intelsat 27 column properties the auto
nom
to true in its gonna give me an identity
marking on the generated the DL
Video Length: 02:08
Uploaded By: Bekwam, Inc
Published: 11/17/2013
View Count: 2,262