|
|
Home : Business : Calculators & Converters
ConversionTool
ConversionTool Details:
| Publisher:
|
BI Garant BV |
| Version:
|
4.2.2 |
| License:
|
Shareware |
| Price:
|
$299.00 |
| Operating Systems:
|
Win95,Win98,WinME,WinXP,Windows2000 |
| System Requirements:
|
MDAC 2.8, JET Comp 4.0 |
| File Size:
|
3.07 MB |
| Total Views:
|
271 |
| Total Downloads:
|
1 |
| Rating:
|
 (5 out of 5 Stars) |
| Release Date:
|
8/25/2005 |
| Last Update:
|
2/27/2006 |
|
|
|
Screenshot:
|
Please click to display full view of
ConversionTool screenshot.
|
ConversionTool Short Description:
Comprehensive conversion of Access to SQL Server, BTrieve re-engineering
|
ConversionTool Long 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,
ConversionTool Keywords:
database, converter, MS Access, SQL Server, ADO, DB Explorer, ETL, Extract, Transform, Load, BTrieve
|
|
|
We deliver articles like below right to your inbox for free:
Using InstallAware 7 To Deploy Microsoft .NET Framework Applications
by Candice Jones
Overview This whitepaper describes how to use InstallAware for deploying applications running on the Microsoft .NET Framework. Although the .NET Framework makes deploying applications easier thanks to features like the Global Assembly Cache, which eliminates shared resource conflicts often encountered by Win32 applications, there are still unique challenges to the deployment of .NET applications. One significant challenge is the download and installation of the .NET Framework, whi...
A Desk on Top
by Alexander Cherepnev
How many application windows do you have open during your typical computer work? If it's just one, you may stop reading at this point. If, however, you do have a clutter of windows on your computer desktop - go no further, you've just found the solution! Windows offers a convenient way to access applications and documents you use often by placing shortcuts to your computer desktop. These shortcuts are fast to click, but what if you have a window or two on top of your desktop? Minimizing...
Discover How PC Satellite TV Software Works That Lets Users Watch Unlimited Free Internet TV!
by Philip Sumpter
The term PC Satellite TV has so many different variations such as Satellite for PC and Satellite TV on PC that you can become quite confused if they didn't reflect a specific name of a software. Nevertheless for this article, I decided to use the first term to represent all the software available over the Net since it has the most number of searches on Google with the phrase Satellite TV included. The other two terms came in a distant second and third respectively. However there comes an...
Things You MUST Know About Implementation of Ecommerce Solution!
by Anne Catherine
Watching new business launched in market must have made you assume that it's way too easy. Let me clear this misunderstanding. It's easy to get a name, but not easy at all to get fame and a good name. It"s never easy to get your business processes online successfully. You have to work out a lot for it. Recently, the famous research firm Gartner Group failed because of poor planning and unrealistic targets on a new technology. Generally, companies are at loss and disadvantages not only because of...
Photo Editing Software Feature Review - Top 3 Photo Editing Software Programs - Become a Pro
by Richard Seng
What are the Features and Advantages of using Photo Editing Software? Photo editing software brings the photo finishing lab to your computer desktop for a minuscule of the cost. Never again will you have to worry about capturing just the right angle with just the right amount of light. You will be able to upload from a digital camera, a removable storage device (CD, or zip flash drive), scanner or digital camcorder to easily edit your images. Photo editing software allows one to...
|
Recommended Products:
|
|
|
|
|
|