Re: Optimization of data migration

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thank you for your help

"fleo" wrote:

> Many thanks for your help Alan!
> I read the article and got puzzled by the "source physical file". Is there
> something equivalent when migrating to SQL Server?
>
> I am definitely not an expert on DTS so maybe I'm missing something and
> being too simplistic. I had in mind to create an OLEDB connection to the DB2
> database and copy the data "as is" in a staging database. Maybe I could
> perform some sort of filtration at the same time??
>
> Then I would transform/copy the data to the real database...
>
> "Allan Mitchell" wrote:
>
> > To move the data you will need to understand the differences between DB2 and
> > SQL Server. The ranges stored in datatypes may be different, there may be
> > completely incompatable datatypes. The list that I gave you will help to
> > optimise the load. What it will not do is tell you the differences between
> > SQL Server and DB2. This article does it in reverse though
> >
> > http://www.redbooks.ibm.com/tstudio/dataware/migrate/index_4.htm
> >
> >
> >
> >
> >
> >
> > "fleo" <fleo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:80BB64EE-83F3-4D66-B7AF-614FF4EE80D3@xxxxxxxxxxxxxxxx
> > > Yes I need to perform cleaning/transformation.
> > >
> > > All the info I found put the emphasis on migrating the database itself
> > > rather than the data. Do you know where I could get information about
> > > migrating the data? The pitfalls, the things I should check in the source
> > > data, how to design the DTS to be able to go from developpement to test
> > > and
> > > production phases, ...
> > >
> > > Thank you
> > >
> > > "Allan Mitchell" wrote:
> > >
> > >> It could well be worthwhile having a staging area yes. This way your
> > >> data
> > >> can go through a series of screens to clean things up and when it reaches
> > >> the end of the process is ready for insertion into the real destination.
> > >>
> > >> do you need to do cleansing or is it a stright pick up and move?
> > >>
> > >>
> > >> Allan
> > >>
> > >>
> > >> "fleo" <fleo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > >> news:62DC12EE-AC4C-4543-905A-F16257FB6C6D@xxxxxxxxxxxxxxxx
> > >> > "Allan Mitchell" wrote:
> > >> >
> > >> >> A few things that run off the top of my head.
> > >> >>
> > >> >> Make sure that you have the appropriate indexes on the Source to
> > >> >> facilitate retrieval of the data to move,
> > >> >> When inserting to the destination removes indexes and triggers.
> > >> >> Move only the data you ctually need to move
> > >> >> Fast Disks
> > >> >> Fast CPUs + cache
> > >> >> As little distance as possible betwen Source And Destination (fast
> > >> >> Network)
> > >> > Thanks Allan.
> > >> >
> > >> > I found papers on migrating from Oracle, MySQL, ... but nothing on
> > >> > DB2??
> > >> > (http://www.microsoft.com/technet/interopmigration/sql.mspx)
> > >> >
> > >> > I am going to be migrating the data only (not the objects). I have
> > >> > seen
> > >> > multiple options and I am not sure about the best way to go. Should I
> > >> > create
> > >> > a staging database?
> > >>
> > >>
> > >>
> >
> >
> >
.

Relevant Pages

  • [Full-disclosure] Details for BID 18428
    ... DB2 Universal Database is a popular database software package ... DB2 UDB server. ... handshake process with the server, causing the server process to crash. ... The first message used by a client when establishing a connection to the ...
    (Full-Disclosure)
  • [Full-disclosure] Team SHATTER Security Advisory: Multiple DoS in JAR files manipulation procedu
    ... Team SHATTER Security Advisory ... All versions of IBM DB2 Database Server on Windows platform. ... DB2 has multiple vulnerabilities which can lead to Denial of Service ... Vendor was contacted and a patch was released. ...
    (Full-Disclosure)
  • Team SHATTER Security Advisory: Multiple DoS in JAR files manipulation procedures
    ... Team SHATTER Security Advisory ... All versions of IBM DB2 Database Server on Windows platform. ... DB2 has multiple vulnerabilities which can lead to Denial of Service ... Vendor was contacted and a patch was released. ...
    (Bugtraq)
  • Re: Connection problem with Access
    ... CurrentDb.Name produced the path to db2). ... As far as permissions go I have given myself 'administer' rights on ... everything, including the database. ... almost every time I have seen documentation for the ...
    (microsoft.public.word.mailmerge.fields)
  • RE: DBD::DB2 question need an example
    ... list database directory ... LI0124E Invalid argument value. ... can you run the following commands from the DB2 CLP ... means that DB2 is not liking something about your $dsn. ...
    (perl.dbi.users)