ConversionTool v.4.2.2

Advertisement
Advertisement

Tool reengineers BTrieve databases and converts comprehensively Access databases into SQL Server preserving all table structure details, and supports the conversion of the views and procedures. Moreover, the tool supports solution of problems. Our tool reengineers BTrieve databases and converts comprehensively a MS Access database into a SQL Server database, unlike the Microsoftls 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 donlt 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.

Tool reengineers BTrieve databases and ...

 
  • ConversionTool
  • 4.2.2
  • BI Garant BV
  • Windows 9X, ME, 2K, XP, 2003
  • Demo
  • 3.08 Mb
  • 230
  • $299.00
 
 

Review ConversionTool

  • captcha
 
 
New Miscellaneous software
  • Doxillion Document Converter Free  v.4.27Doxillion Free Document Converter Software is a multi-format converter and the fastest way to convert DOC, DOCX, PDF, WPS, Word, and many other file types. With this free software, convert text documents within minutes.
  • AMGtime Lite for iOS  v.2.11.2.0The AMGtime app is a component of the complete AMG Attendance System. The application unlocks employees ability to punch in or out remotely from pre-assigned locations, using just their mobile phone. It is the perfect app for a mobile workforce!
  • DreamPlan Home Design Software Free for Mac  v.5.22Home Plan and Landscape Design Software for Mac that is free and easy to use. See your dream floor plan with customized kitchens, bathrooms and bedrooms for a home or apartment. Plan out your landscape. Customize paint, textures and decorations.
  • Artwork Collection Database  v.2.00The Artwork collection database is perfect for artists, collectors, galleries or anyone who wants to record detailed information and images of their artwork collection, including the artwork's provenance, exhibits, publications, and previous sales ...
  • Cookbook  v.2.0Cookbook is a recipe database management system. You may create your own categories and then add recipes to your database. You may also edit, print, copy, mail or save your recipes as a text file. You may also import text files when adding new recipe ...
  • MySQL Excel  v.3.0softgalaxy ...