Oracle SQL Developer: Online Migration 3.1

Using Oracle SQL Developer 3.1 to migrate a Sybase database to Oracle.

---

Closed Caption:

hello my name is tomorrow nail and i'm
going to show you how to do a quick
migration use an article sequel
developer the first thing to note is
Marco secret developer is available for
free upon otn can download the product
comes in the zip file is unzip it into
any director you want and off start so i
am going to start up here
so going to do this from scratch i'm
going to end and migration of the side
base database just to get a feel for and
hope that it's going to take about 10
minutes okay well first off we need to
connect to an Oracle database because
we're going to migrate to an Oracle
database but we also need an oracle
database to even begin migration because
sequel developer uses a set of tables
which we call our migration repository
to hold information about the migration
so we need an oracle database just to
create those tables in so i'm just going
to connect the system this kind of like
my super user i suppose and i'm going to
create a brand new schema in here for
the migration or positive tables on the
create going to put in a new scheme
because i'd like to blow it away i'd
like to drop that scheme at the very end
of the migration so attorney just to put
those tables inside its own scheme you
need a couple of privileges here unique
brand connect resource and create you
call this
demo migration repo same password
because i'm lazy
okay i'm going to create a new
connection to that
so this is just an empty scheme at the
moment doesn't have any table to
practice around thing I can right-click
on it and choose migration repository
associate migration possibly and this is
creates the tables it requires sequel
developer to kick-off immigration
okay great that's complete now i need to
connect to my side base database and if
you look at connections again you can
see that i'm using an option for oracle
our access it doesn't give me an option
yet for sequel server side waist or any
other database so the first thing I need
to do is actually download the jts
driver because we use the J tds driver
for sequel server connections and
sideways connections that we don't use
Microsoft's own jdbc drivers don't use
side bases on jdbc driver has to be this
particular driver and not only that has
to be a particular version after moments
were only supporting jts 1.2 so the
latest version here is no good have to
download an older version than that
this is this is a jts is an open source
project is a performer sourceforge can
just google it and find where it is and
you want to download that 1.2 driver
that download as a zip file menu in
extract those files there's one jar file
and they're called jts 1.2 that jar
that's what I want to use so i've
already downloaded this so i can start
using a straightaway so you got the
tools preferences
and then set inside the database
preference the satyr party jdbc driver
and we want to add in our jts jar file
there okay
now want to try and take connection i
got my Secret Service sizes are
available to me so i'm going to create a
slightly connection here to the standard
samples database inside basis called
pups to how this one doesn't have a
password
yeah
ok so props to you have to retrieve the
data base first and there's always
default database that when you connect
to
so even though you may have to server
details you still have to choose a
default database this connection is
related to so you that first thing you
can test the connection and we can
connect to it so now we have a
connection to side with state ways we
can actually browse all the databases
are slightly server should say we can
browse all the databases going to look
down here see the tables we could try
and allows you to browse most of the
objects in sideways
there's no way that one let me try
another one I'm but it's not this
browser isn't fully featured as
obviously the one would have oracle for
example when you're right and clicking
here we don't have a wizard to help you
create new tables and sybase we don't
have a lot of dead actions that we would
have an Oracle connection we do allow
you to browse the objects and not run
queries as well so i have a worksheet
here that's the connection is against my
side base database and I can still do a
simple queries and things like that so
we want to get this just kicked
migration off so what we have is a
wizard you can right click on the
database or the connection itself and go
migrated to article and this wizard is
going to walk you through the entire
migration and end at any stage you can
say okay I just want to perform to
capture part i want to perform my great
part i don't actually do to move the
data yet any stage can always click
proceed to somebody page click Next
which will bring out the last page or
you can just click finish and just kick
off I'll just kick off and perform
whatever steps have already outlined so
won't if I if I click finish here it
won't go ahead and start doing capture
anything that's asked me here was the
connection for the repository is called
emigration repo i give this a product
name
their migration an output directory
a demo migration director here i'll use
that this structure is used for when we
have to generate or save some files we
can save it into that directory
I'm gonna do this online but there's a
couple of options here on an offline
i'll choose the database 12 pumps to so
now that's going to capture app ops 2
into migration repository it's not going
to and only capturing the metadata at
this point it's not going to capture the
actual data in the into the database but
just metadata about the tables and
procedures can perform convert the show
you the default data type mappings
target database i wanted to go into my
system and this is important to remember
here that we're using this connection
system to migrate over into our Oracle
database but the objects themselves by
default won't be craves inside the
schema so i won't be created inside
schema are inside system schema what's
going to happen is we use the system's
game it to create brand-new a brand new
schema and inside the brand new schema
we have we put the objects so and the
table and procedures will reside on the
side and reside underneath the system's
gamer going to drop the target object as
well because I've performed this before
so this just gives a clean slate
it's also an offline mode here but it
won't talk about that amount i'm going
to move the data as well from sybase
using my systems game again the data is
not pumped into the system scheme but
because it is a powerful enough for our
privileged schema i can use this to move
data into other schemes so that's
everything
this is just a quick
breakdown let's kick it off so it's
going to capture information into a
partially converted into a converted
model which is still lives in the
repository then it's going to generate
script is going to run that script
against my oracle database and create
the objects and the schemas then once
the objects are created is going to move
the data over that the way we're moving
data here is called online data move
it's only really suitable for smaller
data set that's complete so now if I
just have a quick look at the migration
projects you can see we've captured
database converted databases these are
just models inside our migration
policies are not real databases such as
you can see what would happened and you
can see maybe an example a procedure
that would have got converted so if I
right click here and choose compare
compare original see this was the
original t sequel this is the converted
PL sequel we can see that there's also
schema here called dbo all the Scopes 22
and create a connection to that
and when we brought this is a real
oracle database now that we've just
created we can have a look at the orders
table and see that the data was moved so
that's the hard part done if we click on
anywhere here on our migration tree we
can see there's a number of migration
reports and someone will help us find
out well what's missing or what but what
about not valid to these will help us
figure out any the problem static we
were encountered and we can resolve them
so that's a very quick 10-minute show
chantel how you can migrate sideways
database is much more to it than not but
that that's the general flow so thanks
very much