Exporting SQL Datatbases to Access and Dbase programmatically in Vb .net

By nosa2 ·
How do you export SQL 2000 Databases into Access and Dbase by means of using Visual Basic .Net and C# programs?


This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Structure as well or just data?

by Tony Hopkinson In reply to Exporting SQL Datatbases ...

Basically you read it in from one and write it to the other.

Google ADO.Net, but this will be fragile, limited and above all hideously slow and a severe network hog.

Why don't you just export it from one and imprt it to the other. Lot of re-inventing of wheels in this.

Probably not very round ones as well.

Look at DTS.

Collapse -

Exporting SQL Databases to Acess/Dbase

by nosa2 In reply to Structure as well or just ...

I want to do both the structure and the Data. I have used DTS to perform this function. All I really want to do is for the users of my program to be able to export the SQL databases that my program is running on to Access and Dbase. I have been able to provide the "export to Excel" option in the program, from searching through forums like this.

Collapse -

It's do able

by Tony Hopkinson In reply to Exporting SQL Databases t ...

but really really painful.
A heck of a lot of work.
Discovering the schema (unless you are 'hard coding it, giving you versioning problems), then translating it. If your database is simple and you don't need things like user/ ciolumn permissions sp, triggers et al. (and never will) then it's just donkey work.

You can access the table meta data (Column names and types) potentialy translate, then creteat the table, then the data (pssibly having to condition that as well.

What you are doing though is reinventing DTS.
How about just calling the DTS package?

Collapse -

Calling the DTS Package

by nosa2 In reply to It's do able

Thanks for your help and input. How do you call DTS Package programmatically without user?s interaction with the DTS Package wizard? When I did the DTS Package, I told it to save it as a VB file, I went in to try to run the program. There were so many errors and with my level of programming skill I gave up trying to make it work.

Believe me, the last thing I want to do is reinvent the wheel. If you can show me an easy way of interacting with the DTS through the use of codes, I will greatly appreciate it and I will put this nagging headache to rest. Once more, thanks for your help.


Collapse -

Google DTS run time

by Tony Hopkinson In reply to Calling the DTS Package

it'ss a wee app that come with DTS you just give it the package saved as a file and off it goes.
You'll need to look up ShellExecute and VB if you haven't run another file from VB before.

Collapse -

Executing a DTS Package

by nosa2 In reply to Google DTS run time

Thanks for your reponse.
I created the dts package and saved it as a package file.

In vb .net I called the package with the Shell command like you suggested, I got an error message. I called it thus: Shell("TestPakcage.dts").

When I call the package from the SQL Enterprise Manager using the Data Transformation Services to open the package, it works. Is there a way of calling the DTS to open the package from vb?


Collapse -

Shell doesn't understand file associations

by Tony Hopkinson In reply to Executing a DTS Package

ShellExecute is what you want.

Collapse -

Exporting Data to Access/Dbase

by cballinger In reply to Exporting SQL Datatbases ...

What you are describing is the perfect fit for ETL (Extract/Transform and Load). The tool I've used to do this type of work since 1998 was Data Junction (Now owned by Pervasive) and now called Data Integrator. Even if it involves data transformation between SQL 2000 and Access or DBASE it is much, much faster than any VB or C++ developer could ever be and load/run time is measured in seconds, even on a PC workstation. Check out their web site at and look for Data Integration tool for more info. Using connectors you can go from many different sources to many different targets in record time and perform a vast array of data transformations if necessary.

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums