Re: RE: Creating PRD environment with no data
Viva la Devolution! Viva la Devolution! I can hear the battle cry all the way from the midwest. There is also the traditional approach, you create the new environment on the Deployment server running the installation planner. that will give you a clean slate. If there are certain tables you want populated, you can than do a backup of your PY database, and then import specific tables through SQL. I'm not a DBA, so don't pin me down for specifics.
Going the other direction, I've seen our DBAs clone the whole database, and then use the SQL drop command to drop the data. At other times, I've seen them do a table regeneration to clear things out. Do you have a DBA on staff, or are you it? If you're it, you might want to hire a DBA consultant for a day or two for that process.
Have fun and remember our chant, Viva la Devolution!
Gregg Larkin
Praxair North American System Admin
JDE CNC and Security, Websphere, Tidal, Princeton Softech