|
Home > Archive > Sybase Database > April 2006 > Is dumping from partition and loading to file possible?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Is dumping from partition and loading to file possible?
|
|
|
| I have an ASE 12.5 production server at work that is using raw
partitions. It's a small database and not heavily used. I also have a
development ASE 12.5 server here at home, but due to hardware
limitations, I am using a file based scheme. Both hosts are sparcs
running Solaris. Is it possible for me to take a dump from the
production db and then load it on the development db which is using
files?
thanks,
jim
| |
| Mark A. Parsons 2006-03-30, 8:23 pm |
| That shouldn't be a problem ... same underlying hardware and same OS ... so
same endianess.
The question of 'raw vs file' basically comes down to a question of whether
or not your I/O writes are buffered in some sort of cache. If the I/O
writes are buffered then you stand a chance of losing some data (and
possibly corrupting your database) if the system crashes before the
buffered writes can be written to disk.
'raw vs file' has no affect on the format of the data written to disk by
Sybase, so dumping a database from one Solaris/SPARC and loading into
another Solaris/SPARC should not be a problem.
Dumping and loading a database across dislike platforms may or may not be
supported/doable ... it all depends on the endianess of the platforms and
the version of ASE.
Jim wrote:
> I have an ASE 12.5 production server at work that is using raw
> partitions. It's a small database and not heavily used. I also have a
> development ASE 12.5 server here at home, but due to hardware
> limitations, I am using a file based scheme. Both hosts are sparcs
> running Solaris. Is it possible for me to take a dump from the
> production db and then load it on the development db which is using
> files?
>
> thanks,
> jim
>
| |
|
| Thank you for your words of encouragement. I just finished doing it.
The only problem I had, I wasn't running the backup server on my
development machine since I don't back it up. Now I feel a bit silly
asking about it as it was almost too easy.
-jim
| |
| Sanjeev 2006-04-04, 9:23 am |
| Yes Jim its very much possible.
Jim wrote:
> I have an ASE 12.5 production server at work that is using raw
> partitions. It's a small database and not heavily used. I also have a
> development ASE 12.5 server here at home, but due to hardware
> limitations, I am using a file based scheme. Both hosts are sparcs
> running Solaris. Is it possible for me to take a dump from the
> production db and then load it on the development db which is using
> files?
>
> thanks,
> jim
|
|
|
|
|