IS it recommended to use sybmigrate to go from ase 15 2K page to ASE 16 4K Pages

[former_member1185006]

I have never used sybmigrate,

would you recommend to use it Instead of bcp out bcp in?

Performance vise which one is an advantage?

[former_member89972]

Why not use replication.

With ASE 16 + REP 15.7.1 SP306+ (or later) , you can set up definitions + subscriptions with direct load materialization for each table from source (2k) to target (4k). This allows one time load + changes till the time you decide to cutover. Use single threaded direct load to avoid locking issues on target side.

Upfront scripting legwork will allow you to automate most the steps and run them as needed.

Use ddlgen to get the objects from source to taget.

Best "pros" for this approach

- Down time will be minimal. Just shutdown old 2k server and flip IP + NAMEs to the new 4K server.

- Also gives you time to test applications side by side on old 2K and new 4K servers.

Cons

Some effort is needed to code, test and get the scripts in place

Avinash