If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Applications & Tools > data migration from proprietary system to SQL server db

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-11-06, 05:17
gorgenyi gorgenyi is offline
Registered User
 
Join Date: Mar 2005
Posts: 92
data migration from proprietary system to SQL server db

Dear All,

I'm having to manage data migration from a proprietary db system to an in-house designed sql db.

Is there anyone out there who dealt with this and used software or services of companies specialising in this?

All ideas are welcome, thanks in advance!
Reply With Quote
  #2 (permalink)  
Old 09-14-06, 15:11
pkstormy pkstormy is offline
Moderator
 
Join Date: Dec 2004
Location: Madison, WI
Posts: 3,925
What is the proprietary db and how are the data tables stored (i.e. betrieve)? There's usually a way to convert almost anything providing you have the right tool for the job. I've converted several different types of data systems. You can usually find a few companies specializing in this or you can also find a few freelancers out there who'll do the job a little bit cheaper. Depending on how many tables there are and the current structure and if you want it normalized/changed in some way is where the price usually comes into play. Can you get to the actual data tables or are they locked behind the scenes? I had one instance where I had to go back to the developers of the application to design an export routine to get the tables in a manageable/importable state. Plus there's also the front-end design.
__________________
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On