cyberdinn
Posts: 3
|
| Posted: 09/23/2006, 4:29 AM |
|
Hi,
I've to rename a table in my database, let's say "table_a" to "table_b".
This table is already used many times in my CCS project.
How can I handle this ?
Should I do a 'raw' search and replace with an external tool ? or do I have to do this in CCS ? but how ?
Please, let me know the best practice to accomplish this.
Regards.
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 09/23/2006, 6:50 AM |
|
Think carefully about Why you have to rename the table.
You will have to go through all your pages and effectively change them all if you do change the table name.
You can also alias table_A as table_B for any new programs (just guessing at the Why).
Depending on your skills and the DB used you could even do more advanced substitutes.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
cyberdinn
Posts: 3
|
| Posted: 09/23/2006, 8:18 AM |
|
Thanks for advices ,
seems to be very 'acrobatic' ..... 
My problem is that 'table_a' already exists on production server !
It look likes i'am going to have a bad week end 
|
|
|
|
peterr
Posts: 5971
|
| Posted: 09/24/2006, 2:06 PM |
|
You can use any search & replace tool to rename "table_a" to "table_b" in all .ccp files.
Only first backup the project just in case.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
cyberdinn
Posts: 3
|
| Posted: 09/24/2006, 3:16 PM |
|
Thanks a lot Peterr for this confirmation.
|
|
|
|
|
