Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm looking to set up a recurring data import from a very old, R-Base 4 database, into SQL Server 2008. I know close to nothing about R-Base databases - is there any way to do this?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

You're going to have to roll your own. You can use SQL Server Integration Services to pull data through the RBase ODBC connector. SSIS can manage the change detection stuff for you, but when I say that, I don't want you to get the impression it's going to be easy.

The good news is that SSIS is a pretty mainstream technology at this point, so you could hire a consultant to build this kind of thing for you.

share|improve this answer
    
I've come to pretty much the same conclusion. Drats. –  blueberryfields Oct 18 '10 at 19:32

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.