AW: EOModeler Question
AW: EOModeler Question
- Subject: AW: EOModeler Question
- From: Helge Staedtler <email@hidden>
- Date: Mon, 25 Jul 2005 10:44:25 +0200
For changes also beeing reflected in your deployment-DB after you have done
all the testing in development, the following stuff might come in handy...
http://wocode.com/cgi-bin/WebObjects/WOCode.woa/1/wa/ShareCodeItem?itemId=42
4
Just collect all of your SQL-statements and put them in this stuff, to
distribute the changes in the database to ALL live-systems on deployment.
But read the corresponding article carefully before starting with this...
...you need to know what you are doing. ;-)
Regards,
Helge
Am 25.07.2005 8:16 Uhr schrieb "Anjo Krank" unter <email@hidden>:
> Apart from that, it's a good idea to put this stuff in a file
> changes.sql under version control. That way, you know what you did
> and can apply the same changes on your deployment machine... you have
> version control and a deployment machine, do you?
>
> Am 25.07.2005 um 06:22 schrieb Kieran Kelleher:
>
>> Just make the desired change to the database directly. In general,
>> EOModeler can give you "auto-generated SQL" for you to use in
>> creating your initial database, however it is often prudent to make
>> db structure edits directly using command line SQL such as "ALTER
>> TABLE mytable ...." or use a database GUI editing tool.
>>
>> So, when you tweak your EOModel, you need to make corresponding
>> tweaks if applicable to your SQL database structure, especially
>> when you want to ensure the integrity of existing data.
>>
>> -Kieran
>> ________________________________________________________________
>> Blog: http://webobjects.webhop.org/
>>
>>
>> On Jul 23, 2005, at 2:29 PM, Darich Runyan/OMNI INFOSEC LTD HQ wrote:
>>
>>
>>> All,
>>>
>>> I am fairly new to WO still; although, I do have one production
>>> app online
>>> and working nicely. I need to add a field to the database that I
>>> am using
>>> with the app without drop and rebuilding the tables. I added an
>>> attribute
>>> for the new field in the model but can not find how to have
>>> EOModeler modify
>>> the table in the database without dropping the current table and
>>> rebuilding,
>>> which would obviously present a problem. Can this be done through
>>> EOModeler
>>> or do I have to add the new field via commandline/sql tool as well
>>> as adding
>>> it to the model?
>>>
>>> Thanks,
>>> Darich
>>>
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list (email@hidden)
>>> Help/Unsubscribe/Update your Subscription:
>>> 40mac.com
>>>
>>> This email sent to email@hidden
>>>
>>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>> 40logicunited.com
>>
>> This email sent to email@hidden
>>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
--
Helge Städtler
Franz-Liszt-Strasse 16
28209 Bremen
tel. 0421 626 5 929
mobil 0177 5453559
- Expect and Respect.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden