Transfer database structure and data from MS SQL server

CodeLover
CodeLover used Ask the Experts™
on
Hi, all

I used SQL Server for a web site using JSP. I am considering using interBase 6 instead of SQL Server as its database. Could you please tell me how to transfer all the database structure and data to interBase? Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
First, an assumption: You've searched the internet for conversion tools and ruled out any of the existing software. Without knowing how complex your database is, this is a GENERAL answer:

I can see a couple of phases here:

#1 Extract SQL metadata / logic from SQL Server.
i.e. the table structures, triggers, stored procedures.

InterBase can digest that in one long file, once it's properly syntaxed. WISQL, the default interbase query tool can run a file like that.

#2 Determine data dependencies.

If your data tables depend on each other, determine the order most optimal for adding the least- or non-dependent tables first, and adding the dependent tables later.

#3 Use a tool to migrate data across OR generate 'insert' statements from SQL Server.

Delphi can be set up to help "datapump" your information from one source to another. There is most likely something in Java to accomplish the same feat. I'm not familiar enough with SQL Server tools to know if something can dump the data as "insert" statements that could be run against InterBase but that's also an alternative.

Questions for consideration:
How complex is the database ?
( Number of tables, foreign keys, triggers, stored procedures, BLObs present ? )
What sort of tools do you have at your disposal ?
Languages ?
Time ? Money ?
 


kacorretired

Commented:
Hi CodeLover,

if you got the needed answer, please accept it by clicking on Accept in the header of the good answer. By this way you can express thanks for expert's support

with best regards

Janos
kacorretired

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
       to accept vogonPoet's answer
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

kacor
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial