At present we are using Informix 9.21.

We are thinking of shifting to other database as not much maningful support is available for Informix. But before that would like to have some views / advice from other users.

Is it advisable to move to MS SQL Server ?

We are on BAAN C4, Windows 2000 and IDS 9.21 with 70 GB of data size. We expect the data size to increase by another 20 GB in next one year.

What is the comparision between the following 3 databases with respect to Baan C4
1) Informix
2) MS SQL
3) Oracle

cheers........
Vineet
:)

SQL Server on Windows 2000 just got a boost with the addition of the
level 2 driver, that would make it plenty scaleable for your size database.

Don't forget db2! it DOES have support and you might get a discount
being an informix customer looking to migrate.. Plus it has a level 2 driver as well, its small, simple and fast!

I'm an oracle guy myself, and I don't particularly like Oracle on Windows, its never been quite there in my opionion.

Dave

Yes ofcourse give me the comparision between the following 4 databases with respect to Baan C4
1) Informix
2) MS SQL
3) Oracle
4) DB2

On what level you want comparison?
- Performance?
- Price?
- Scalability?
- Marketing?
- Integrations?
- Future?

70Gb can run on all databases, but maybe you have something particular that makes the choice easier in one or another direction.

For what reasons do you want to move away from Informix?

Kind regards,
Dick

It is primarily based on price / performance and finally on ease of use and ofcourse reliability.

But all views are open with me.

Is there any particular virus related issue with MS SQL as it is a Microsoft product. What about reliability of the database.

Well,

I have worked on all the databases listed above except db2. In my opinion Ms - Sql Server is the easiest to use , cost wise also it is cheaper, some people prefer Oracle because of level2, but now i belive ms-sql server too supports level 2.

Informix is a good one , but gui is not strong , u can always go for ibm tools which provide gui interface.

yes, if your ms sql server is not updated with sp3a or the respective patch, then it is prone to sql slammer virus. For more information about this virus, you can visit the site :


http://securityresponse.symantec.com/avcenter/venc/data/w32.sqlexp.worm.html
http://www.microsoft.com/security/slammer.asp
http://www.cert.org/advisories/CA-2003-04.html

Regards

Neeraj Vasudeva