Data conversion

  • Thread starter Thread starter js
  • Start date Start date
J

js

Hi,
Usually how people do the data conversion? For example, I have a well
defined database, the new client use another similar relations database and
have few years data in it, he want to migrate to my system, so I need to
convert his data into my database, customer, appointment, transactions,
etc.)



Is it a cool way to handle this? Please advice.
 
js said:
Hi,
Usually how people do the data conversion? For example, I have a well
defined database, the new client use another similar relations
database and have few years data in it, he want to migrate to my
system, so I need to convert his data into my database, customer,
appointment, transactions, etc.)



Is it a cool way to handle this? Please advice.
Click to expand...

If this is a one-off scenario, you need to scope out the migration with
a complete mapping of the source and destination databases and any
scrubbing that needs to occur to the data, design the migration code,
test it repeatedly on a test server and then run it in production when
it's ready. You can use DTS to help with the migration if the data
scrubbing is involved. If not, you may be able to do this using T-SQL.
 
Thanks David,

"David Gugick"
If this is a one-off scenario, you need to scope out the migration with a
complete mapping of the source and destination databases and any scrubbing
that needs to occur to the data, design the migration code, test it
repeatedly on a test server and then run it in production when it's ready.
You can use DTS to help with the migration if the data scrubbing is
involved. If not, you may be able to do this using T-SQL.
Click to expand...

Is it any articles available to learn?



This is not a one-off scenario (depend on the clients system) , the business
logics in general are deal the same, for example, custom info, order info…,
but they can represent different in the field name and size…

I did lots of data conversion use queries before. Just wander there are good
ways (or tools) out there can simplify the process?



Use DTS in my case is slow, I could use it wrong, because I always use it to
process the records by row to massage the data. Using T-SQL (deal with
large set of data), it is faster. Is it right?
 
Back
Top