[Full source code release] Heterogeneous Database conversion tools

 This is an introduction to the use of this software post, software structure introduction: http://dragonpro.cnblogs.com/archive/2006/04/09/370889.html

In my opinionOracleAndSqlserverIf you want to copy data and structures between databases, it seems to be a problem. Of course, there will certainly be similar or better tools. However, because I am naturally lazy and don't want to find them, I simply wrote a tool myself, you canSqlserverAndOracleTo convert any combination of data. Currently, this tool is built onMicrosoft Enterprise LibraryThe above blocks data operations between different databases, so that you only need to consider business issues when creating this tool.DaabSmall instance of the module.

Software:

[Configuration ]:

You must configure two. ConfigFiles, which areDataconfiguration. configAndAppsettings. configThese two files are used to configure the database connection and field ing relationships.

Dataconfiguration. config:

This configuration is usedEntlibModule generation, I believe I am familiarDaabThe module can be easily configured and usedLeftdatabaseAndRightdatabaseThe concept, that is, the left database and the right database in the corresponding section. Here, you need to configure the Left and Right databases respectively. For example, the left database can beSqlserverAnd the right database can beOracleOf course, it can also be vice versa, and it can also be the same type of database, this instance is connectedSqlserverDefaultNorthwindDatabase, remember to create an empty name before starting the softwareNorthwind2As the target database for testing. If you are not familiar with this configuration, referEntlib.

Appsettings. config:

This configuration file is the ing between database fields, suchSqlserverInVarcharIngOracleInVarchar2, Which are described in the configuration file and can be understood in general.

[Operation ]:

After the configuration is complete, you can runProgram(Of course, you can use my default configuration to run directly, but you need to create the defaultNorthwind2Such an empty database is used as the target database ). Shows the software interface:

• First, click the connect database button in the upper part. At this time, the program automatically connects to the left and right databases based on the configuration. The corresponding tables in the database are listed in the left and right lists below. The database connection string is displayed in the drop-down basket to prevent data import from being uncertain or missing the configuration.
• If you want to import a table from the left database to the right database, select the corresponding table name in the left list basket. Note that you must check the corresponding table name before you think you want to import the table.
• Select the import option in the lower-right corner.
• Click the arrow to the right, and the program will start to export data after the prompt is confirmed. At the same time, the following status prompt shows the current import progress, number of imported items, and log status.
• After the import is complete, the program prompts and stops running.

[Note ]:

Using this program, I successfullySqlserverImport to databaseOracleDatabase.

This program is not perfect, for example, inSqlserverImportSqlserverIn databases, primary key indexes cannot be created, and general indexes can only be created. Considering that this tool is generally used for data exchange in heterogeneous databases, it will not go further.

The program is completely open-source and has no version restrictions. You can copy and use it as needed.

Click to download]

[My other open-source projects]