What is the best way to move the entire database from one installation to another. I've seen many, many options and I have yet to have to much success with any. The object here is an OS upgrade, not Sybase so I guess what I'm looking to do is duplicate what is on the old NT4 server to the W2k server. Unfortunately a Sybase Upgrade as well is out of the question.
I was under the impression I would be able to create the new device, database and somehow do a dump of the data and all to the new database. I though it would be more efficient dataspace wise. Unfortunately I am not all that familiar with the DBA tasks in Sybase. To tell you the truth I'm not even to sure that the way the dev and database was created is as efficient as it could be.
As far as exporting, BCP seems a little clunky. I would have to dump each and every item indiviually including all stored procs, but it's not out of the question. I guess I could write somekind of sp to do it...
Is there a best way ? If not, some opinions would be helpfull hurt or even some pointers from someone who's been here before.