|
What is the best approach to build a small (but scalable) application that works with Sql Server or Oracle?
I'm interested in build apps that supports multiple databases, in the process behind the feature.
Started by Jonathan on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
You could look at either should just have to swap out the ....
That way youUsing an ORM that supports multiple databases is the first step here.
NHibernate or Entity framework for example - both have oracle and sql server support.
|
|
So many companies today want someone with Oracle experience. I have none, but it seems to me that it shouldn't be hard to figure out quickly. However, when potential employers ask me if I've worked with Oracle, the line "No, but I'm an expert with Microsoft...
Started by Joshua Carmody on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
The hard parts, and the valuable skills server....
However a DBA, or a senior database programmer, just to write ANSI SQL.
If only for a time.
Stick an MS SQL DBA on an Oracle database and there just lost.
And it's guis.
|
|
At the moment I pull data from remote MS SQL Server databases using custom-built JDBC connectors. This works fine but doesn't feel like the way to do it.
I feel I should be able to put a JDBC connection string into tnsnames on the server and have it "...
Started by Nick Pierpoint on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
With Oracle being such keen Java fans, and with a JVM built-in to the database I'd have thoughtGeneric Connectivity....
For Generic Connectivity, if you're running on Linux...
With the database license and Oracle Gateways is an add-on.
|
Ask your Facebook Friends
|
I have Oracle SQL Developer already installed and am able to connect to and query Oracle databases.
Using Help -> Check for Updates I was able to install the Oracle MySQL Browser extension but there are no connection options for MySQL databases.
Started by Craig Hyatt on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You can download the MySQL.
Here is a demo on How to Create a Database Connection for MySQL .
Under Tools > Preferences > Databases there is a third party JDBC driver path that must dialog.
|
|
The application part of my database is in Access 2003, and I use tables that are linked from SQL server. Now, I have some tables that I have to link from an Oracle database. I link them through and ODBC connection and it works fine. Is it possible to ...
Started by Jasmin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
That connection!? I what to establish connection from sql server to oracle database link! Is that possible_SQL linked server sources are handled very much like local databases and can be queried individually mapping....
|
|
Our development databases (Oracle 9i) use a remote database link to a remote shared database.
This decision was made years ago when it wasn't practical to put some of the database schemas on a development machine - they were too big.
We have certain schemas...
Started by A_M on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
[EDIT....
Ideally, just build a test case which tells you:
The SQL is correct (it parses) It operates correctly with a few document the test data you're using.
Copy the relevant data into your development database and create the tables locally.
|
|
I need an example C# source code that abstracts databases (easy to change from one database to another with minimal code modification). Do you know some sample sites or tutorials with good quality?
Specific target databases are as follows:
1. Microsoft...
Started by yoitsfrancis on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
For instance:
public static IDbDataAdapter GetDataAdapter (Database....
To approach this is to use the interfaces provided by the database providers; they are nearly parallel, and connections, based on the database which is configured.
|
|
I have access to an Oracle server that has some databases that I would like to access. However, the machine that I have access from has none of the oracle client software. Is there any alternative to oracle's client software the provides the functionality...
Started by Paul Wicks on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You can use that without doing any sort of Oracle client install if you so ....
If you download the free Oracle Instant Client you'd be able to use any JDBC or ODBC Database tool of databases, obviously including Oracle.
|
|
We are designing a fairly large brownfield application, and run into a bit of a issue.
We have a fairly large amount of information in a DB2 database from a legacy application that is still loading data. We also have information in an Oracle database ...
Started by MattGWagner on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
This makes it possible to query your DB2 database real time and you can....
Which can "Combine data from disparate sources such as DB2, Oracle, and SQL Server into a single you create a database link from Oracle to DB2.
|
|
Is there a tool that allows me to change my password in multiple Oracle databases?
It expires every month and I would like to change them all simultaneously.
Started by Jack on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
And then create sql job), and specify a target group (if defined) or manually choose which target databasesYou could change your password in 1 database (I haven't done this in a number of years - so try this carefully - Last time I did....
|
