Our tool reengineers BTrieve databases and converts comprehensively a MS Access database into a SQL Server database, unlike the Microsofts UpSize Wizard preserving all table structure details, and supports the conversion of the views and procedures. Moreover, the tool supports solution of structural problems between Access and SQL Server like making the implicit behavior of boolean fields in MS Access explicit in SQL Server by setting the default to FALSE and making the field required.

We understand that not everything can be converted automatically. First of all, there is the complexity of translating database functions into their SQL Server counterparts. Add the problem of user-defined functions (in VBA), where VBA code would have to be translated into SQL Server syntax elements in a user-defined function.

But there are also decisions to make regarding changes in the client application. Take a view for example with two fields of two different tables with the same name, which is possible in Access but not in SQL Server. MS Access would expose field names like [.] in order to make the name unique, but since SQL Server does not allow such a syntax, the fields would need to get another name; with all consequences for client applications using this view.

To deal with all these problems, our tool converts everything it can automatically. All remaining items are identified, the problem is shown clearly to the user, and an interactive mechanism is provided. If, for example, a record could not be inserted due to a constraint violation (a wrongfully inserted date like 1/1/199), this insert instruction is logged in a separate error log, and can be edited and executed. When a referential constraint fails, our tool creates automatically a view in both the source and target database, containing the foreign key records, which dont match a primary key.

Our tool is also prepared to convert from or to other database systems. Starting with version 2.1, any source databases can be converted to SQL Server.

Product keywords: database, converter, MS Access, SQL Server, ADO, DB Explorer, ETL, Extract, Transform, Load, BTrieve

Top downloads in category Free SQL Compare 1.0 New Release Compares the structure of two SQL databases and display all differences. OS:Win98,WinME,WinNT 3.x,WinNT 4.x,WinXP,Windows2000,Windows2003 Freeware 0.42Mb Date: 11/30/2004 Downloads: 232 AdeptSQL Diff 1.60 Build 25 Minor Update Database schema difference viewer and synchronization tool for MS SQL Server OS:Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 Commercial 1.30Mb Date: 01/18/2005 Downloads: 205 DTM SQL editor 2.02.68 Major Update Set of powerful database management tools: ODBC support, schema viewer, builder OS:Win98,WinME,WinXP,Windows2000,Windows2003 Demo 1.36Mb Date: 01/15/2005 Downloads: 201 Visual Importer 3.4.82 Major Update Loads data into Oracle,SQL Server,ODBC, from flat files, cross tables or ODBC. OS:Win98,WinME,WinNT 4.x,WinXP,Windows2000 Shareware 4.12Mb Date: 12/22/2004 Downloads: 193 DTM Data Editor 1.01.22 New Release Database viewer and editor with BLOB import/export options. OS:Win98,WinME,WinXP,Windows2000,Windows2003 Demo 1.16Mb Date: 01/15/2005 Downloads: 189 EMS IB/FB Manager Professional 3.8.5 Minor Update Simple and powerful GUI tool for InterBase server adminitration and management. OS:Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 Shareware 4.28Mb Date: 12/08/2004 Downloads: 187 Database Tour 4.9.9 Minor Update Universal database tool with integrated report builder OS:Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000,Windows2003Server Shareware 1.52Mb Date: 12/25/2004 Downloads: 187 Aglowsoft SQL Query Tools 3.0 Major Update Advanced SQL Query Builder for any ODBC-compliant databases. OS:Win98,WinME,WinNT 4.x,Windows2000,WinXP,Windows2003 Shareware 5.07Mb Date: 01/13/2005 Downloads: 186 EMS MS SQL Manager Professional 1.8 Minor Update EMS MS SQL Manager is a tool for MS SQL Server administration and development. OS:Win95,Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003 Shareware 4.51Mb Date: 12/14/2004 Downloads: 186 ADDA(Advanced Data Dictionary Architect) 1.0.5 Minor Update Multipurpose toolkit for designing and maintaining the database layer OS:Win98,WinME,WinNT 4.x,Windows2000,WinXP Commercial 3.93Mb Date: 11/07/2004 Downloads: 184