Hello everyone, I recently met a problem, I need to connect interbase database, version is 7.5, the older; I want to tell interbase database content, imported into the SQL server database; Set up an ODBC database; I through SQL server data import and export function, can see interbase data, the following graph:

Choice - the.net Framework Data Provider for ODBC; Fill in the information, the odbc can display properly interbase database, and the ability to preview the contents of the database;



When I import the execution, there will be a mistake, I'm wonder if it is possible, will be directly through the odbc connection to interbase database, written in SQL data, display, insert into the database, thank you very much;

CodePudding user response:

Suggest you to create a good link server:
https://blog.csdn.net/yenange/article/details/9456145

Query table can directly link to the server:

 
Select * from [link server name]. [the database name]. Dbo. Table name 

All can query, don't need to import and export,

Do you want to insert to the native database table, just like the following:

 insert into table (c1, c2) 
Select c1 and c2 from [link server name]. [the database name]. Dbo. Table name