database load in different platform

[Kopperton]

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

 

[TomBascom]

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

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.

 

[Kopperton]

Tom it is binary dump and script is vendor supplied

 

[TomBascom]

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):

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.

 

[Kopperton]

is it ok to turn the vendor supplied load script into a windows batch script?

 

[TomBascom]

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.