Re: InterBase/MS SQL Server data port

[Robert Castaneda]

Hi John,   A GUI interface comonly used is the SQL Explorer (again ships with Delphi/C++Builder) - but there are others. One you can get from ibobjects which I think is the type of thing you're after. http://www.ibobjects.com/IBOWISQL.html     Transferring of data from one db to another is traditionally done using the Borland Database Engine (BDE), which is a part of the Delphi product. The BDE is a similar architecture to ODBC or JDBC , where there is a common abstraction layer and various drivers for databases. A "Data Pump" shipped with Delphi to grab data from one and place in another.  And there are some components that can also help.   If you can grab a copy of Delphi Client/Server or Enterprise you cxan gete these tools. They also exist in C++Builder and (If memory serves me correct - early versions - 1 & 2 - of JBuilder)   One thing to be careful of is the mapping of datatypes from one type of db to another.... I would get the db structure created via a script and then use a tool to import the data. This way you can use the triggers and generators etc. inside InterBase.     Hope this is useful to you,     -Robert   PS - I'm not subscribed to the Servlet or JSP list, so if you think this is of use to them, then please send it to them.     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John McDonald Sent: Monday, May 01, 2000 9:42 AM To: ejboss Cc: ejb-interest; A mailing list fordiscussion about Sun Microsystem's Java Servlet API Technology.; A mailing list about Java Server Pagesspecification and reference Subject: InterBase/MS SQL Server data port Slightly off topic here, but a question for all none-the-less.   Does anyone know of a way to port my data(or just the table structure themselves) from MS SQL Server to InterBase? It will take me a week to re-create all of the tables i have in my sql server if I have to recreate them manually. Also, are there any GUI utilities out there that I can use to create my tables, instead of having to use InterBase's Interactive SQL utility? It's crazy to me to think that InterBase doesn't have a utility(like MS SQL Server) that I can use to create tables. am I missing something?   Thanks to all who respond.   -jdm- web app guru ClientScience.com, Inc. p 925.373.8700 f  413.793.6603 e [EMAIL PROTECTED]