If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: need some ideas

I have this old sybase database (use sybase sql server 11)
sitting on the old linux server. I want to convert or
upgrade to a window based database because the server is
pretty old (I am fraid it maybe broken one day) and there
is not linux expert here. Any good idea for this? Thank you
very much!
tian

1 Ensure you think about the following carefully:
- unless you run Sybase ASE 11 on the new windows machine, you will get different results from your queries (SQL is different from each vendor)
- linux is infinitely more stable than anything MicroSoft ever did (or ever will) produce.
- it runs much faster on linux than on windows
If it aint broke dinnae fix it.

2 Sybase 12.5.x is much faster than 11.x, if you have a licence then you are best advised to migrate to it. Read the Migration Guide and follow all steps.

3 If you do move to either Sybase 11/12 on filthy windows that need constant attention, or worse, if you move to SQL Server <insert year/bug count>, as long as you name the server the same, you will not have to "repoint" the applications to it. That is leave the interfaces (or sql.ini) file unchanged.

Cheers

Derek Asirvadem
Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTauAnything worth doing is worth doing Right The First Time
Spend your money on standards-compliant development or spend 10 times more fixing it