tags:

views:

222

answers:

1
Q: 

How do I have multiple schemas per database connection in Eclipse DTP?

I'm using the Eclipse DTP to do my SQL development. When I create a database connection I'm promoted to enter the name of the database (schema), and I cannot continue until I enter it. However, I have several databases on each server, and I want to see them all under the database connection (like most the database tools let you).

Can I do it in eclipse?

A: 

For each database your should create new Database Connection at Data Source Explorer. Database connection represent one-to-one mapping database «atomic user instance» (for example, for oracle this is instance name/user name, for hsqldb in server mode databse location and so on) to connection.

St.Shadow  2009-10-21 08:44:07
The database connection is to my development machine, where I have root access. I need to access 4-5 schemas. Do you mean I need to create 4-5 database connections? Also, in the SQL editor I can relate the sql to a database connection, and there is another drop down which let me select the schema. Problem is there is only one schema...
David Rabinowitz  2009-10-21 09:37:04
Which db do you use?I down`t find way, how to add multiply shemas with Oracle or HSQLDB.
St.Shadow  2009-10-23 12:59:34

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL