ArnorBld
Posts: 12
|
| Posted: 11/25/2008, 4:31 PM |
|
Hi all,
I have just got CodeCharge Studio and started playing with it. One of the things I want to do with it is to take the BugTracker example and convert it to use MySQL and use on our website for our products. The example comes with an Access database so I need to convert it to MySQL script to construct the tables etc. on my MySQL server.
Has anyone done this before and if so would you be willing to share the SQL script? If not, can anyone point me to a tool that could re-engineer the database (I have PowerDesigner somewhere and I expect I could use it for this)?
Many thanks in advance:)
Best regards,
_________________
Arnor Baldvinsson - Icetips Alta LLC |
 |
 |
ArnorBld
Posts: 12
|
| Posted: 11/25/2008, 5:13 PM |
|
Addition: It is a project created with the "Task Manager" Solution that I'm working on.
I've got the basic SQL created with PowerDesigner so I may get this working:)
Best regards,
_________________
Arnor Baldvinsson - Icetips Alta LLC |
|
|
|
Gena
Posts: 591
|
| Posted: 11/25/2008, 10:40 PM |
|
Could you tell us what is BugTracker example?
_________________
Gena |
|
|
|
Gena
Posts: 591
|
| Posted: 11/25/2008, 10:42 PM |
|
do you mean Task Manager example?
oop. yes
You can find sql scripts (including Intranet_MySQL.sql ) in Examples\Intranet directory
_________________
Gena |
|
|
|
mentecky
Posts: 321
|
| Posted: 11/26/2008, 2:47 AM |
|
Arnor,
Download the MySQL GUI tools from the MySQL site. One of the tools is "Migration Toolkit". It has the ability to convert an ODBC/Access DB to MySQL with a few clicks in a Wizard.
You can find the download here:
http://dev.mysql.com/downloads/gui-tools/5.0.html
Rick
_________________
http://www.ccselite.com |
|
|
|
Gena
Posts: 591
|
| Posted: 11/26/2008, 3:04 AM |
|
mentecky,
Arnor don't need to migrate or convert data, all sql scripts are already available in Example directory for different sql, for example:
Intranet_MSSQL.sql
Intranet_MySQL.sql
Intranet_Oracle.sql
Intranet_PostgreSQL.sql
_________________
Gena |
|
|
|
mentecky
Posts: 321
|
| Posted: 11/26/2008, 4:32 AM |
|
Gena,
Thanks, I actually did not know that. 
It's been a while since I looked at the examples.
Rick
_________________
http://www.ccselite.com |
|
|
|
ArnorBld
Posts: 12
|
| Posted: 11/26/2008, 8:54 AM |
|
Hi Richard, Gena,
Thanks for the advise:) I completely missed the .sql files in the Intranet folder and went straight to the TaskMan folder, where they aren't<g> Good to know about the converter, Richard, that could come in handy!
Best regards,
_________________
Arnor Baldvinsson - Icetips Alta LLC |
|
|
|
Gena
Posts: 591
|
| Posted: 11/26/2008, 9:28 AM |
|
Arnor, you are welcome!
btw you can ever check Internet directory as well, so you can find sql scripts for the Internet examples.
Normally all examples (including 3rd party) for CCS comes with sql script so you can easy generate DB with all neccessary tables and data.
and personally I don't use ms access database for design time and change it to use mySQL database instead, so I have the same database and structure for both mode.
_________________
Gena |
|
|
|
ArnorBld
Posts: 12
|
| Posted: 11/26/2008, 10:54 AM |
|
Gena,
Thanks:) I don't think I will use this as it only has a part of what I need but this - along with the tutorial video that I found somewhere - has given me some good starting points on how best to get started on my little project:)
Best regards,
_________________
Arnor Baldvinsson - Icetips Alta LLC |
|
|
|
