Import from multiple type of database to an SQL Server database API

Question

0.00/5 (No votes)

See more:

Hi,

I am working right now on a project that require of me to import data from an external database, the external database is of an unknown type.

I am very busy and I don't have the time to develop the entire solution so if possible tell me if there is any useful api(taking as input the connection string and the other required configuration).

Thanks before hand.

Posted 14-Feb-11 4:17am

Houssem K.

Updated 14-Feb-11 4:29am

Henry Minute

v2

Add a Solution

Comments

Henry Minute 14-Feb-11 10:31am

Can you run SQL queries against the unknown database?

Houssem K. 15-Feb-11 2:45am

it is up to the user to create a user that i can use to perform my task.

so i think the answer is yes.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nish Nishant · Accepted Answer · 2011-02-14T04:31:00

Solution 1

You should be able to write a migration app that copies structure and data from most common databases using ADO.NET or OLEDB. But it probably won't be a quick one day job. So if you don't have the time, you may want to invest in a commercial software solution that does the job.

Posted 14-Feb-11 4:31am

Nish Nishant