wcboyd
Posts: 46
|
| Posted: 07/03/2006, 1:41 PM |
|
Hello All,
Is there a way to push/publish only the database portion of a project to the production server?
Thanks.
_________________
Thanks,
Craig
"Stress is the body's way of saying you have not worked enough unpaid overtime." ~ Scott Adams |
 |
 |
peterr
Posts: 5971
|
| Posted: 07/03/2006, 1:55 PM |
|
You can right-click on the "Common Files" node in Project Explorer and select "Publish". Common files include the database configuration.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wcboyd
Posts: 46
|
| Posted: 07/03/2006, 2:00 PM |
|
peterr,
Thanks. I see the following files in my target/production directory:
CalendarNavigator.
Classes.php
ClientI18N.php
Common.php
DatePicker.html
DatePicker.js
Functions.js
Navigator.php
Sorter.php
Template.php
db_mysql.php
db_odbc.php
BTW, this is the TaskManager appliction w/a MySQL database.
But when I look in the MySQL database I don't see my files there. Should I be using one of the files above to import the table definitions into MySQL?
Thanks again.
Craig
_________________
Thanks,
Craig
"Stress is the body's way of saying you have not worked enough unpaid overtime." ~ Scott Adams |
|
|
|
peterr
Posts: 5971
|
| Posted: 07/03/2006, 2:05 PM |
|
CodeCharge Studio has no relation to a database or publishing it. It can only connect to an existing database, either on your computer during testing, or on your server. The published programs expect that your database is already setup and available to connect to.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wcboyd
Posts: 46
|
| Posted: 07/03/2006, 2:09 PM |
|
Hmmm. So DB changes are handled "outside" CCS and then you have to incorporate them into your code, right?
And in my case, for a brand new DB I need to convert Access to MySQL, right?
Thanks.
_________________
Thanks,
Craig
"Stress is the body's way of saying you have not worked enough unpaid overtime." ~ Scott Adams |
|
|
|
peterr
Posts: 5971
|
| Posted: 07/03/2006, 2:15 PM |
|
Yes, all this is correct. This process is similar to manual coding where you would write your programs separately from creating, publishing or converting a database. CCS is used to speed up the coding, but not related to the database setup process. Database changes would also need to be incorporated into the code, whether created manually or using CCS.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
wcboyd
Posts: 46
|
| Posted: 07/03/2006, 2:19 PM |
|
Got it.
Thanks for your help Peter.
Craig
_________________
Thanks,
Craig
"Stress is the body's way of saying you have not worked enough unpaid overtime." ~ Scott Adams |
|
|
|
