|
| |
| MS Access |
|
|
| MS SQL |
|
|
| MS FoxPro |
|
|
| MySQL |
|
|
| PostgreSQL |
|
|
| DBConvert Scheduler |
|
 |
|
|
|
|
You are welcome to post us your questions about our products and we enlighten them in our FAQ section.
|
|
|
|
|
|
-
What are the primary differences between DBConvert and DBSync series?
All «DBConvert» versions convert data from source to destination database. If you don´t have a direct access to the server or have an ftp and PHP access through phpMyAdmin or other tools, «DBConvert» can create «Dump» and «PHP Script» files which contain database info inside and can be executed on the server for putting database there.
You can find more details about conversion at:
http://dbconvert.com/conversion.php
«DBSync» versions can both convert and synchronize databases. It strictly needs the direct access to server. «DBSync» provides three types of synchronization:
- Insert synchronization
- Update synchronization
- Drop synchronization
You can find more details about synchronization at:
http://dbconvert.com/synchronization.php
-
Is it possible to run your product from the command line?
Our converters guarantee an appropriate running and handling
from command line. You should use the following example for DBConvert for MS Access&MySQL when running the program from the command line:
Example:
C:\Program Files\DBConvert\Access2MySQLPro\Access2MySQLPro5_Cons.exe /Session:"Session Name"
Where /Session:"Session name" defines what precreated session should be used
This option lets you run converter with the settings which have been stored as a session. All passwords are saved too.
You can find more detailed info about command line using in our on-line manual at:
http://dbconvert.com/manual.php
-
What maximum number of rows and tables can be converted?
The size of a database you attempt to convert can be limited by DBMS and restrictions related to the data types which are defined in DBMS. Conversion speed directly depends on database size, its structure complexity and hardware set on your PC.
-
Do your converters allow to choose data fields?
Our products convert such database elements as tables, fields and indexes. If you needn´t convert your whole database there is an option to convert certain table, field or index from a source database. You simply can customize your conversion settings.
-
Do your converters synchronize in both directions?
Our synchronizers can handle data in both directions but not simultaneously. At first, data is synchronized from source to destination database(e.g. from MS Access to MS SQL database ) and then vice versa. Synchronization can be executed in one direction with adding missing records in destination db (insert synching) or with editing records altered in source (update synching). If you need to fulfill bidirectional synching you can create 2 sessions arranging sequential synching from A to B and vice versa from B to A.
|
|
|
|
|
|
-
I get «Error 1005: Can't create table... ».
MySQL server reports this error when:
- The referenced table is not an InnoDB table
- The referenced column in other table is not unique
- The referenced column in other table has a different type to other id
In MySQL prior to 5.0, this error can also indicate that:
- No index has been defined on the column id
-
I get «Error 1062 Duplicate entry '1' for key 1». What can I do?
You should customize synchronization properties correctly by checking "Insert sync" and "Update sync" options for all tables. At the same time you need to have, at least, one unique primary key field per table you want to synchronize. Otherwise, synchronization works incorrect or doesn't work at all.
|
|
|
|
|
|
-
How to connect to Microsoft SQL Server 2005 Express database?
There are 3 ways of connection with MS SQL. You can do it through :
1. - TCP/IP
2. - IPX/SPX
3. - PIPE
Our tool uses TCP/IP protocol for conversion process by default. You should open this protocol through MS SQL Configuration Tools.
If you still can not connect to the server check firewall settings or reconfigure your MS SQL server using one of the ways described above.
Also make sure that password field is empty if you log in as super administrator.
|
|
|
|
|
|
-
How can I convert MS Access forms to a web-page?
The general idea of DBForms from MS Access to PHP+MySQL product is conversion of MS Access forms to web page. It may be needed when you want your users have access to data through web resource. Converted forms performed as php files are presented in web browser Exactly the way they were created in MS Access.
-
What additional software should I install for conversion with DBForms from MS Access to PHP+MySQL?
Before running DBForms from MS Access to PHP+MySQL you should have the following software installed:
- MySQL server
- PHP
- Web server (IIS)
In case you don´t want to adjust settings of MySQL server, PHP and IIS working together we can recommend you to use «3 in 1» package products, such as:
- WAMP
- XAMP
- Netserver
- Denwer and many others.
They require the minimum of user´s participation. After package installation these 3 components work together perfectly.
Note: Pay attention to additional libraries supplied with web server that must be loaded for work with PHP. Please read PHP and Apache help files if you intend to configure them manually.
-
Why were the forms not converted?
More likely, the problem is masked in unconnected MySQL database with PHP script language. Also you can check folders structure where converted form files must be saved.
In case form conversion is committed successfully and the main problem is in uploading php files to local folder or FTP server you can find "Templates" directory. Usually it is placed at "C:\Documents and Settings\User_name\Templates". Here A2WebForms folder must be created. So all php form files can be simply copied from A2WebForm folder to your local folder specified at Upload setting stage.
-
How can I create Front/Back Ends in order to remote users could log on to the MySQL database online?
At the moment the program doesn't convert events for elements. You can add your event code in your forms manually. For this purpose, go to the folder where your resultant forms are located. Each form is converted to a separate folder which is named in the same way as the form. Choose the folder you need. In this folder you will find "UserFunction.php" file, which contains function header for buttons.
Function name always has prefix "Button" followed by the name of this Button.
For example:
function ButtonOrders(&$Fields)
{
//TODO: Add your code here
}
NOTE!
When working with this function remember that:
1. the path to the folder where your resultant forms are saved is as follows: ./../
2. the path to "FORMS" directory is as follows: ./../../FORMS/
For example:
You need the following functionality: You click at "View" button and "My_Form" is displayed.
Your event code should be as follows:
function ButtonView(&$Fields)
{
header("Location: ./../../FORMS/My_Form/My_Form.php");
return FALSE;
}
If you don´t want to add event code manually or develop Front/Back End web interface we can perform this service for extra fee.
|
|
|
![](images/z.gif"){kind=small}
