If you can get access to MSSQL 7.0, the Data Transformation Services (DTS)
can be quick and helpful sometimes, allowing you to specify ODBC and other
datasources and column/datatype mappings. You can design GUI data pumps and
tasks and also using VBScript for more complex mappings if needed. I've had
both great success (very quick and painless) and dismal failure (back to
some other method) depending on different data sources and complexity etc.
Regards
Joe
> John McDonald wrote:
>
> 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]
--
Joe Shevland
Principal Consultant
KPI Logistics Pty Ltd
http://www.kpi.com.au
mailto:[EMAIL PROTECTED]
"Support bacteria -- it's the only culture some people have!"
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
