| suggestion regarding data copy into other user [message #457264] |
Sat, 22 May 2010 10:49  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Dear All
I need any good suggestion basically I have two different location
1- Factory
2- Head office
I have developed PRODUCTION module in factory and it is working fine and now I want to send data on daily basis to head office therefore I develop a form which will create backup in export format (.dmp) then user will send via email to head office.
Backup file should be save in pre-defined location then user will use a form which I developed for loading data into head office there are two different buttons in this form;
First is used to load data, actually first I load data in a temporary user which creates whenever user will press this button.
Second is used to copy data in application user but first it checks if data exists then update otherwise insert.
This is my whole scenario, which I am using but I think you guys can give me any other better solution/option.
|
|
|
|
| Re: suggestion regarding data copy into other user [message #457275 is a reply to message #457264] |
Sat, 22 May 2010 15:28  |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I'd use operating system's scheduler to perform export and mail it.
I didn't understand the penultimate paragraph ("First is used ..."). What is created? A temporary user? If so, that's most probably wrong. You shouldn't create users that way. You shouldn't create tables either. If, for some reason, you think that that part of job should be donen in a "temporary" schema (I'd rather call it "a schema different from production one"), so be it. Just create all objects you need and use them. Once you don't need data any more, truncate tables (i.e. do not drop them and create again tomorrow).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
