> I need some help, i installed sybase on linux a month and half ago and
> works great...
> i originally created a database call it database1 on the master device... of
> i need to move this database1 to a new much larger device...
> i created a new device of 200mb called device1 and everything is fine.
> now how do i simply & the least complicated way move database1 from master
> although ive been developing with sybase & dblib for a few years
> im new to this type of procedure and dont want to blow up the database, its
> is there a simple easy way to do this, i
> cant seem to find any instructions, or howto's on this type of move.
> ive read dump and load, but picking through the docs, i dont want to just
> run commands without knowing
> what will happen!
Here would be the easiest, safest way:
use the "dump database" command to dump and image of the database to a
filesystem file or a tape (choice of /work/dump1 is arbitrary, pick
an appropriate location, it has to be able to hold 20mb in this case).
dump database database1 to "/work/dump1"
create a new database on device1 with a size at least as large
as the original db (can be larger)
create database foobar on device1 = 20
load the database image into the new database:
load database foobar from "/work/dump1"
Satisfy yourself that foobar contains your data.
Drop the original database:
drop database database1
Rename the foobar to database1:
sp_renamedb foobar, database1
Once you get your confidence up, you can do what most people
do, which is to dump the database, drop the original, create
the new db (with the desired name), load the database. But
the above sequence is a wee bit safer.
Bret Halford Imagine my disappointment
Sybase Technical Support in learning the true nature
3665 Discovery Drive of rec.humor.oracle...
Boulder, CO 80303