从多种类型的数据库导入到SQL Server数据库API [英] Import from multiple type of database to an SQL Server database API

问题描述

我现在正在开发一个项目，该项目需要我从外部数据库导入数据，但外部数据库的类型未知.

我很忙，没有时间开发整个解决方案，所以如果可能的话，请告诉我是否有任何有用的api(将连接字符串和其他所需的配置作为输入).

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.

推荐答案

您应该能够编写一个迁移应用程序，该应用程序使用ADO.NET或OLEDB从大多数常见数据库中复制结构和数据.但这可能不是一天的快速工作.因此，如果您没有时间，则可能需要投资做这项工作的商业软件解决方案.

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.

这篇关于从多种类型的数据库导入到SQL Server数据库API的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！