• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Replicate Menus Using SQL

epost

Active Member
We are planning on copying some menus into production. The following SQL
seemed to work when we copied it from dev to usa. Anyone aware of any
problems in doing it this way? Am I missing any tables?

- Ethan Post
- Oralce DBA

insert into usactl.f0082 (select * from devctl.f0082 where mnmni like
'G57MALAY%')
/
insert into usactl.f00821 (select * from devctl.f00821 where mzmni like
'G57MALAY%')
/
insert into usactl.f0083 (select * from devctl.f0083 where mtmni like
'G57MALAY%')
/
insert into usactl.f0084 (select * from devctl.f0084 where mpmni like
'G57MALAY%')
/
commit
/


------------------------------------------------------------------------------
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

==============================================================================
 

rafaelrv

Member
Ethan:

I did that kind of copy but in B7332 over SQL Server, the copy was allright
but we have troubles in some menus with the intercativity, and we had to
copy with the tool tha OW had, Record Copy on GH9081.
 

pareano

Member
Hi Ethan,

We're on an Oracle backend but I use that same SQL all the time and it works just fine...

Paul
 
Top