Here is the situation: We have a test/development box and a production box. They attempted to copy our production company data to our development company data. What I was told was that company 000 became corrupt. So they copied company 000 from production to development. Needless to say we lost all of our development vrc data. The only good news is that the program scripts are still there. BUT without the tables even those are useless.

Is there a way to take forms or the tables dictionary and import these back into company 000? I can see all the files out on the UNIX box but, not in our test company. Any possible way to reload them.

Mark

Mark, I don't think so. There is no way you can recreate application data from runtime data. Best thing to do is get a backup tape and start restoring. You do have a backup right?

No backup. We just found this out today. I work in Louisville,Ky. and our servers are managed in Minneapolis. Our Oracle and Application Admins. sit up their. I was really hoping I could import the forms/tables - if they ever fix my logon. If what you said is true, then I am going to lose just about everything on a couple of big projects I was working on, not including somethings I developed only for the test VRC. :(

I do not think the admins want to talk to me at this point.

Mark

Mark,

I feel for you right now. No backup = BAD, IRRESPONSIBLE. Time for management to kick some ass I would say. Have you ever exported your work as dumps that you could re-import? Maybe even very old ones. But old is still better than nothing.

I agree. This is not the first time that the lack of backups has burned us. The first was in production. We were doing some Baan error correction programs, the backup was suppose to happen Thursday night. It failed and they went on with the error correction schedule. Needless to say the programs updated incorrectly and we needed to restore and couldn't. Sorry for venting, but needless to say I am very mad.

I better stop or take it offline before I say what I am really thinking. :)

Mark

I work in Louisville,Ky. and our servers are managed in Minneapolis

managed?

Thanks ~Vamsi I needed a laugh.:) At this point one of the Oracle admins seems to think they will be able to find an oracle export of company 000 for our test server. I have my toes, fingers, eyes, legs, and anything else I can think of crossed. :)

As it is when and if the company comes up I am going to develop my own backup for the app. group.

Mark

Hi Mark,

Thats hard to imagine, we have a daily backup of our dev and qa environments.

Additionally, we also have a DR(disaster recovery in the East USA) and a hotback before we go any big code migrations etc on our Production box.

I wonder what kind of setup/strategy do your BaaN/Oracle Admins have.

Something to cheer you up -

Free Advice (http://www.geocities.com/siliconvalley/garage/7941/advice.html)

Dont forget to see Jackie Chan... :p

It is official now - I am screwed no backup. Instead of relying on them from now on I will take care of it myself. Well at least when I can get back into the company and work.

At least these posts can be used as a warning for other companies.

Mark
(Like Jackie's Rush Hour movies and his cartoon show.:))

Then I would say tar and feathers are in order.

...and a bottle of 'Rebel Yell' for you.

You have my deepest sympathy.

RE: Thanks ~Vamsi ...I have my toes, fingers, eyes, legs, and anything else I can think of crossed.

Mark:

Maybe you can sell video rights to whatever else you crossed to one of those less-reputable websites. (You did back up the mini-cam, didn't you?) One always hopes that after 3-4 decades of professional developemt, IT would stand for something other than a Stephan King novel.

Oh well, the brews are flowing for you at the local pub.

Scott

Mark,

Feel sorry for you. However it must be possible to create the tables again by analyzing the dict files isn't it? Ok, it a lot of work but at least you have something and don't have to invent all again. It must be even possible to create a small script for importing the table definitions again.

Something else, at one of my customer site we always have to export our developments as soon as they are going into production. That must be something you can organize yourself without depending on your admins.

Wish you a lot of succes,
Han

The mini-cam was broken, the local pub ran out of Makers Mark and we had to back order the tar and feathers. So today has got to be better. Maybe they will even give me back my developers permissions. :)

Mark