Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an older application that uses TopSpeed as the database engine. I want to use some of the data contained in these tables in another application that uses SQL. To accomplish this, I purchased the TPS ODBC driver and used Access to move the data from the TPS tables to an SQL database by using the linked tables feature.

This works fine, but I'm looking for an automated solution (plus, the Access way is messy). Is there a tool out there that could help?

share|improve this question
    
Why do you need automation, is the data being updated on the old system? –  vonPryz Sep 17 '13 at 15:34
    
Yes. We have production software using this database, and the software I need to interface with it speaks SQL, so I have to migrate the data on a regular basis. –  Nathan C Sep 17 '13 at 15:42
add comment

1 Answer

up vote 3 down vote accepted
+50

You don't have to use Access as a mediator.

You can look into SSIS or import utility to import data from .TPS to SQL. You have to select Flat file data source.

At the end of the import utility, you will have the option to save the package and then schedule it using SQL Agent job.

Refer to : How to Migrate Data From Top Speed Database Files

Also, look into SSMA (SQL Server Migration Assistant). I have used it for Sybase to SQL Migration, but not sure if it will be good fit for TopSpeed migration.

share|improve this answer
    
Thanks for the links. I'm looking for a more automated method, though. SSMA doesn't support TPS. –  Nathan C Sep 17 '13 at 15:00
1  
@NathanC best is to use SSIS for automation. –  Kin Sep 17 '13 at 18:13
    
Thanks, I think SSIS will be the best method. Something new to learn. It's either that or writing my own program which I don't have the time to do. –  Nathan C Sep 23 '13 at 17:09
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.