|
|
| 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 |
 108 ( -16 -14.81% ) | | 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: | - Paradox to MS SQL Server Conversion Software 7.0 — Transfer tables from Paradox to MS SQL Server 2000 or 2005 databases. This program is designed for Paradox 5 databases. Higher versions of Paradox databases can be saved as 5 and used with this…
- Database Exchange Wizard 3.4.4 — Data Exchange Wizard can import data from a text file, Excel spreadsheets, or MS Access databases into any database, including Oracle, MS SQL Server or any ODBC compliant database. Alternatively, data…
| | 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 —…
- ProxyInspector for ISA Server 2.6g Appropriate Control — When things get about the corporate Internet usage and traffic control, there always a lot of the loose talks: Either the management needs to control every kilobyte of data transfer and every connection or employees can have certain level of freedom? The answer to this question varies from one organization to another and depends on many factors. However, all agree that the *control is necessary…
- Kwok Information Server 2.3, IT Management with Pleasure — Every IT business, even the smallest one, needs to manage some, at least the most basic kinds of information related to their business. Of course, when it’s a company of «two directors and one worker», it can manage all of its operations through sticky notes or Excel worksheets. But, becoming serious, becoming organized, with multiple orders, clients, employees, and…
- AA Mail Server, Be Your Own Email Service Provider — No matter how hard you try to set up a hosted email service the way you want it to be, chances are that you’ll end up compromising your demands, for it’s hardly possible to have someone do things the way you want them be done. If you want to take control over your email communications, fire up your own email server, and yet not spend much time dealing with…
- Instant Messaging Server. Safe and secure communication. — No one can deny that good communication is a crucial component in the formula of business success. That is why, if you need to be successful and gain extra profit, you need to use the unique Instant Messaging Server and Client software: Bopup Communication Server, Bopup Messenger, Bopup Observer — all these programs belong to a single client-server platform. Instant…
- Server Monitor 3.4.0, Know The Problem In Proper Time — There are two kinds of system administrators: those who think «my system can’t fall» (optimistic kind), and those who thinks «if the system falls, I want to know it as soon as possible» (realistic kind). The second kind of sysadmins are more valuable: they can do wisely even in complex conditions. Server Monitor is a software for those wise…
- ESF Database Convert — Like in that old proverb: so many countries, so many customs. I mean so many countries, so many languages; so many databases, so many formats: MySQL, SQL Server, PostgreSQL, Oracle, InterBase, Access, Excel, Paradox, Lotus, dBase, Text and others…but don’t give up, there is special software that can help you to deal with all of them. It is ESF Database Convert. ESF…
- Backup prOxy Server. Backup belongs to the past - The future is in recovery! — Solutions for data backup and recovery are the frequent theme of reviews, and this frequency has an explanatory background: there is not a more important task than keeping corporate or personal vital data in a safe place. But this task (backup, namely) has one less commonly discussed aspect: what is the *overall purpose* of data backup? Don’t answer immediately; let?s think. The common…
- Unreal Media Server 5.0, Media to Universe — Unreal Media Server is an almost-universal highly-customizable media streaming solution. It can be used with the equal ease either inside a LAN or for the Internet, in an on-demand or live modes, with any level of interactivity and any media format. On the server side, Unreal Media Server supports a huge multitude of media formats (for ex., sound: WMV, MP3, OGG, video: MPEG-2…
| | Find all smart reviews similar on ConversionTool 4.2.2 |
|
