|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 14th, 2004, 08:29 PM
|
|||
|
|||
|
Import from SQL DDL File?
I'm just getting started with Firebird and have an sql file with DDL commands in it to make tables and populate them in a database.
I already created a database with isql. I was wondering if there is a way I can have Firebird run the SQL file to create the tables for me. There are about 50 tables that need to be created and it'd be painfull to do it all by hand. Thanks.
|
|
#2
July 15th, 2004, 04:00 AM
|
||||
|
||||
|
Call isql this way:
isql -i your_script.sql of course your script will have to contain appropriate login informations. It's much like running scripts in Oracle's SQLPLUS.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Import from SQL DDL File? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
