SQL database conversion from Borland InterBase to a Linux SQL database

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration, Platform-Specific Issues

Paul Blamire — Wed, 13 Jan 1999 22:34:20 -0000 — source: Informix-list mailing list archive (1991-1998)

Okay, I'm no database expert, which is why I'm asking. What I'm running now: I'm using a data manager with Pro Engineer for part and drawing storage and management. It uses Borland Interbase 5.1 via SQL and TCP/IP. I currently have a small database which is use to access a number of large data files on the NT server it's running on. The client relies on a BDE alias to access the database server. What I want to do. I want to go to a Linux server, running either samba or netware so the clients can access the database and files. To do that I want to convert the Interbase database to some other format so I can run it on a database on Linux. The BDE alias setup can create aliases for standard, DB2, informix, oracle, sybase, interbase, mssql and access databases. I am thinking that Oracle, sybase or informix are what I want to be looking at for linux, but a 'standard' alias would probably just issue generic SQL requests. I'm not a company, just a personal user, but that will probably change in a few years, so I want a solution that doesn't tie me into paying huge licensing fees if I do become comercial, and even then I am looking at 2-3 users max. Given the above information, does anyone have any suggestions about how to proceed or what software to consider, in paticular how to convert the database, I was think ODBC, does that sound stupid? Thanks in advance Paul Blamire

↪ replying to Paul Blamire

Ken Rachynski — Tue, 26 Jan 1999 19:15:29 -0700 — source: Informix-list mailing list archive (1991-1998)

Paul, Have you looked at Interbase for Linux yet? I haven't seen a recent comparison of Interbase licenses, but I'm pretty sure that Oracle is pricey for 2-3 users. In fact, I believe that Oracle is massive overkill for that many users. Paul Blamire wrote: > I'm not a company, just a personal user, but that will probably change in a > few years, > so I want a solution that doesn't tie me into paying huge licensing fees if > I do become comercial, and even then I am looking at 2-3 users max. > > > Thanks in advance > > Paul Blamire -- Ken Rachynski Database Analyst krachyn@cadvision.com <http://www.cadvision.com/krachyn>; ICQ: 3113514