database load in different platform

Kopperton said:
We dumped the database on unix server, how to load it on windows server. dont have the scripts. any help will be useful
Click to expand...

The answer to "how did you dump it" will go a long ways towards determining how to load it :awink:

ASCII? Binary? An application specific custom data extract?

In general dumping from UNIX and loading on Windows doesn't pose any special problems beyond the normal pain in butt aspects of dealing with Windows.
 
Then wouldn't you also have a vendor supplied load script?

If not then you can either load the files manually with proutil or you could write a program to create a batch file to do it. Something like this (untested):

Code: 
output to "load.bat".
for each _file no-lock where not _hidden:
  put unformatted "call proutil dbname -C load " + _file._dump-name skip.
end.
output close.

Of course that is a single threaded load and it could use some optimization if the time to get this done is limited...

You could also use a different tool. Perhaps something like Highly Parallel Dump & Load.
 
That depends on what it looks like. UNIX shell scripts don't usually translate directly to BAT files. But the general idea can usually be translated without much effort.
 
You must log in or register to reply here.
Back
Top