Windows Forum

Ask something
Discussion Locked

SQL Database

0 helpful
1 reply

by seldom seen 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Forgive me if this question is not worded properly but I am no DBA by a long shot. I am a IT Business Analyst with a project (well part of a larger project) to extract data from one SQL database with key fields into another SQL database (new application) with the same key fields with a few others.

If someone that is SQL proficient can help me ask the right questions to get this done I would be greatful. However, I know it can be done, I just need to know what I need to know to figure out how. Oh and here is another bit of information, the database (old system) has 9 years worth of data, maybe I can convince them to only extract the last 3 years if necessary.

Thanks techy world!

1 reply

by tony hopkinson

Is this a one off migration, or an ongoing transfer. Is the old system being phased out or is the new systrem and add on to the old.

Which SQL DMBS's are involved? Are they the same version?

If it's an on going transfer of data, how dynamic does it have to be. Now, hourly once a day?

This discussion is closed to new replies.