Data Migration Betrieve Tables to MS SQL Server 2005

20 pts.
Tags:
Data migration
Database migration
Migration
Pervasive
SQL Server 2005
SQL Server migration
Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

Answer Wiki

Thanks. We'll let you know when a new response is added.

What to prepare if we are going to migrate instead…. or what are the steps that we should take. Thanks.

correcting and adding my posted question.
————————-

I have several Btrieve databases being pulled into SQL 2005 via SSIS.
Basically you will need to create a connection into the database (ODBC is best here in my experience) and build an SSIS package to pull in the tables (and their contents) into tables in SQL.
You will of course have to write the queries to oull the data in, either the complete contents of the tables, or of course limiting what columns/rows are pulled through. This is obviously a god time to do some house keeping if you need to.
You can either design these tables in SQL yourself or let the server do the work for you (i prefer the former) and have the data imported.

You haven’t said at all though what you are going to do with your data once it’s in SQL….. is it static (data warehouse) or will it be used with an application? This will have a bearing on how you need to import your data i.e. will it be a regular import, or a one off? how will the application migrate if at all? What security requirements will you need to implement in sql?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following