.: ConversionTool 4.2.2

   Our tool reengineers BTrieve databases and converts comprehensively a MS Access database into a SQL Server database, unlike the Microsoft?s 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 don?t 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.

Size

3.07 MB

License

Shareware

Price

299 USD

Category

System Utilities / Utilities

Operating System

Win95,Win98,WinME,WinXP,Windows2000

Developer

BI Garant BV
Program system requirements: MDAC 2.8, JET Comp 4.0

Screenshot:

ConversionTool


Download Now
File size 3.07 MB

Buy Now

database, converter, ms access, sql server, ado, db explorer, etl, extract, transform, load, btrieve,

.: Top Utilities / System Utilities programs

NoteBook 1)   NoteBook 2.04
Stores notes and passwords in a secure file.

ZipZag 2)   ZipZag 1.80
Handles Rar, Zip, Bz2, Ace, 7z, Iso, Cbr, Cbz, Tar, Cab, Jar, Msi, Pk3, Pak, Lzx

VeryPDF PCL Converter (PCL to PDF) 3)   VeryPDF PCL Converter (PCL to PDF) 2.0
Convert PCL to PDF, PCL to TIFF, PCL to TIF, PCL to Postscript

 4)   Public ShareFolder 1.2
Share Outlook without Exchange. The shared PST file as groupware solution.

System Mechanic Professional 5)   System Mechanic Professional 8
Speed up your slow PC. Protect your data from malware and intruders.

 6)   Advanced Windows Cleaner 1.00
Make your PC run faster cleaner, error free and protect your privacy.

 7)   BOS - Backup prOxy Server 2.2.1.9
BOS is Restoring software that recovers files and Outlook/Exchange items easily




.: New Utilities / System Utilities programs

Ultra Shutdown 1)   Ultra Shutdown 1.0
Schedule shutdown,restart,hibernation,locking and stand by options.

EnhanceMyVista Standart 2)   EnhanceMyVista Standart 1.11
An easy to use yet advanced enhancing, optimizing and tweaking tool

WinComponents 3)   WinComponents 1.2
Make your computer work faster! Add/Remove Windows Components!

Lotus Notes Address Book Converter 4)   Lotus Notes Address Book Converter 6.5
Convert Lotus Notes contacts to Outlook with Lotus Notes Address Book Converter

Block Website 5)   Block Website 1.0
Block Website(s) on your computer easily. Backup / Restore Settings easily.

System Mechanic Professional 6)   System Mechanic Professional 8
Speed up your slow PC. Protect your data from malware and intruders.

System Mechanic 7)   System Mechanic 8
Make your PC run like new. Repair system errors for best performance.