|
|
| 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. |
|
| Updated |
Aug 26, 2005 01:35:43 |
| Rating |
 81 ( -9 -11.11% ) | | Size | 3 kb | | Licence | Shareware | | Status | New Release | | Languages | English | | Tags | database, converter, MS Access, SQL Server, ADO, DB Explorer, ETL, Extract, Transform, Load, BTrieve | | OS | Windows 95, Windows 98, Windows ME, Windows 2000, Windows XP | | Homepage | keper.com | | Email | burkhard@keper.nl | | Author | Burkhard Lau |
|
|
 click for full size
|
Description:
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. | Short tags:
database, converter, MS Access, SQL Server, ADO, DB Explorer, ETL, Extract, Transform, Load, BTrieve | System Requirements:
MDAC 2.8, JET Comp 4.0 | |
| | Freeware alternatives ConversionTool 4.2.2 |
|  Free Download ConversionTool 4.2.2 from keper.com |
| Similar software shotlights: | - Data Exchange Wizard 3.6.2.1 — Data Exchange Wizard Loads or export data from/into ANY database. Full support for Excel, Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or ANY ODBC compliant…
- Advanced ETL Processor 2.4.2.8 — Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the “Preview” button and see…
| | Find all software similar on ConversionTool 4.2.2 |
| Similar smart reviews: | - MP4 Converter for Windows, Media Conversion Combine — MP4 is a modern and popular format for media; MP4 is a container format that can store video and audio data (mp4, m4p, m4a). MP4 is in your iPod, in your iPhone, Playstation, Zune, Xbox… Have you ever thought of creating your own MP4 files from existing video and audio files with different formats( AVI, MP3) ? Or, maybe, you are thinking about backwards conversion —…
- MultiExtractor - a universal all-purpose data extraction and conversion tool — The feeling of helplessness is not the best feeling in the world. It is especially annoying when you can see or hear something that you really like, but can’t take it and use again somewhere else. When multimedia files are well-hidden from prying eyes in the depth of resource files and exotic archives, when images are stored in unknown formats and there seems to be no easy…
- OraLoader - simple, fast and flexible data conversion tool for Oracle databases — As a database developer dealing with Oracle databases, you may face the problem of converting your database data to more conventional formats or, on the opposite, filling your database with data provided in standard spreadsheets or even plain text files. These operations may take a lot of time that could otherwise be spent on developing and refining more important aspects of your…
- SWFKit Pro - hassle-free conversion of Flash movies and animations into powerful EXE applications — Macromedia Flash provides virtually unlimited opportunities for creative talents to put their ideas into life. Powerful vector drawing, animation and object tweening tools make it a weapon of choice for ultimate website designs and offline presentations. However, playback of Flash movies always required a special player, so you could not simply open it as you do with regular movies and images…
- Tinysoar DVD Ripper: The DVD Conversion Freeway — Wherever you’re going, to give the trip a bit of excitement, you might want to grab a few of your favorite discs — movies or music — and take them along. You could’ve grabbed them all, if it wasn’t for a tiny problem — they take up quite a bit of space in the luggage. Besides, the only player you might have…
- AscToHTM - quick and intelligent text to HTML conversion tool — Despite the abundance of various text formats these days, plain text still remains extremely popular, especially for lengthy manuals, readme files, books and other types of documents and in situations when size and compatibility are crucial. If you have a large collection of text files that need to be uploaded to your website or face this problem on a more or less regular basis…
- Video to FLV SWF GIF Converter - hassle-free video conversion for your online activities — Despite the great number of video formats used online and offline today, the Flash Video format has become the standard online video format used by such services as YouTube, Google Video, Reuters.com, Yahoo! Video and a great many of websites that feature video materials of all kinds. FLV files are viewable on most operating systems and browsers via standard browser plugins, which makes them a truly…
- FastFotoScale - lightning-fast resizing, cropping and conversion of vast arrays of photos — If you have several digital cameras in your family and often exchange photo archives with your friends, you know how hard it is to manage thousands of photos scattered across various folders on your hard drive, optical disks and memory cards. In addition, photos downloaded from various cameras seem to have identical names and often have different resolutions, which makes it hard to quickly…
- Server Control Tower. PA Server Monitor — “How’s my server doing?” “What’s going on with it now?” “Hope, I haven’t missed anything important.” — These are the most typical things server administrators are concerned with. In order to not miss anything important, some of them never leave their seats. (Or, if there are many servers, they run around them to make sure…
| | Find all smart reviews similar on ConversionTool 4.2.2 |
|
