Re: Optimization of data migration

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"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

  • Re: Optimization of data migration
    ... It could well be worthwhile having a staging area yes. ... the end of the process is ready for insertion into the real destination. ... >> As little distance as possible betwen Source And Destination (fast ... > I am going to be migrating the data only. ...
    (microsoft.public.sqlserver.dts)
  • Re: How do i do the following in DTS
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... in Column1 on the destination, read second row and place column1 in ...
    (microsoft.public.sqlserver.dts)
  • Re: Fixed Field Columns Missing
    ... it's copied to the destination via a VB script. ... > Allan Mitchell MCSE,MCDBA, ... >> In my package design, I'm running a SQL Truncate Table from the Mainframe ... >>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Add row numbers to Text file export
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... "Marinus Willemstijn" wrote in message ... Allan you are right - there is no destination ... >> Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.dts)
  • Re: Differential Data Import
    ... Is this to capture changed rows? ... If you delete 5,000,000 rows then reload them just so you can say you have the latest rows then this will cost whereas if you did a query which said "For those rows that exist in the destination that are on the source has anything changed and if it has update" this would probably be more cost effective. ... "Allan Mitchell" wrote: ... now next time when I run the package I want the ...
    (microsoft.public.sqlserver.dts)