AQUANANU
Posts: 107
|
| Posted: 02/20/2012, 7:45 AM |
|
Hi i have just migrated my databases from ms access to Mysql
The migration was handled by the migration tool of mysql in a breeze.
I had been using the databases with a project in VB ASP on windows server.
Now the SQL statements are giving errors, one i found out was because of USE of [] in statement which are not permitted in MYSQL SQL syntax.
Other i found out was that MS-ACCESS stores true as -1 and MYSQL refers in SQL query it as +1, so the SQL are not retrieving empty any record sets.
Does anyone know how to replace value of boolean field in all the tables across multiple databases from an particular mysql instance or there is any option in mysql to specify it should be read as -1.
Next i want to know, do i need to regenerate the whole project or only the common files to be regenerated and placed on the live server.
On testing the records are not getting updated if they are being updated using custom update or insert.
Please helllllpppppppp!!!!
_________________
Navneet Kakkar
CEO
Positive Thinker's Inc. |
 |
 |
|
