Hi,
I have a huge database (about 31Gig) with the actual data size of
about 16Gig. I would like to shrink the database. I tried doing it the
manual way (BCP OUT, create new database, BCP IN) but as this database
is so big it took a long time BCP the data out and in and being in
production environment with a limited time, I had to role back all the
changes before I could complete the task. I've heard that sybmigrate
could be used for this purpose but I always thought that sybmigrate
could only be used across 2 servers not on the same server! Any
suggestions on using submigrate for this purpose??? Any suggestions on
speeding up the manual way?

thanks, Nina