Tagged Questions
1
vote
1answer
39 views
Data Migration from Oracle to SQL Server [duplicate]
If you need to do a data migration from an Oracle database to SQL server, what approaches and technical solutions are the best practice?
Our database has about 100 million rows and a total of 52 ...
4
votes
1answer
72 views
General tool to load dump files
I am a big fan of Postgres both for its price but also for its features.
I am going to have to need to upload into it both Oracle dump and SQL Server files.
I will try to ask and beg for plain .csv ...
0
votes
0answers
27 views
Oracle to SQL Server DDL replication
We have this customer requirement to do DDL + DML transactional replication from Oracle to SQL Server 2012. The DML part is straightforward. There are multiple options to choose from including the SQL ...
0
votes
4answers
282 views
How can I convert an Oracle dump file into SQL Server?
I want to ask about converting Oracle dump files (.dmp) into SQL Server files (.bak) where during conversion I don't have to be connected to any database server.
I've searched for related ...
0
votes
1answer
81 views
Import data from Oracle to SQL Server [duplicate]
I have an Oracle database in a remote server. I want to import data from it to SQL Server on a local machine using a stored procedure or job shedule but I don't know how can I do it.
0
votes
0answers
57 views
Are there any good open source tools for DB objects end user manipulation?
I've been recently tasked to provide some object adjustment features for our end users, simple thing like changing the value of two or three fields in some specific business know tables without the ...
1
vote
1answer
233 views
SSMS Oracle import using OpenQuery over LinkedServer (Oracle Provider for OLEDB) - XML Parsing: unable to switch encoding
I am trying to migrate the data from an OracleDB to an SQL Server Express database. I'm doing this by openquerying a linked server (data provider based on Oracle Provider for OLEDB). Everything works ...
1
vote
2answers
88 views
PreparedStatement caching size on Oracle and SQL Server
I understand that PreparedStatements are complied and cached by database servers.
I would like to know if all the preparedStatements are complied and cached on the server, in which case what is the ...
0
votes
2answers
243 views
Advice for ETL from Oracle to SQL Server?
I'm building a data mart in SQL Server which needs to extract each month from an Oracle database. Currently this is done by exporting to flat files, then running all the inserts/updates in SQL ...
-3
votes
2answers
172 views
Versioning data in Databases [closed]
Is there any ready mechanism in Oracle, SQL Server, PostgreSql or OR framework (C#), which can version information in a database? By versioning informartion I mean that e.g. I have table Person (id, ...
6
votes
3answers
259 views
Clustered index in SQL Server vs index organized tables in Oracle
I am making the transition as a database developer from SQL Server to Oracle and found some fantastic resources here already (How to make a transition from SQL Server DBA to Oracle? and As a DBA, how ...
4
votes
3answers
270 views
SQL Server pivot query on Oracle source
I have a SQL Server instance that has a linked server to an Oracle server. There is a table on the Oracle server called PersonOptions which contains the following data:
╔══════════╦══════════╗
║ ...
1
vote
1answer
150 views
Missing quotation - openquery to oracle
I am not able to successfully run a code with openquery to a oracle server.
Please do not take into account field names/data types, as I had to present only a part of the whole procedure. It's quite ...
2
votes
2answers
509 views
Average Time to Load 1.2 million records from Oracle INTO SQL SERVER 2008R2
I have an ssis package which loads 1.2 million records of data from oracle into SQL SERVER 2008R2(with 32 GB RAM) dataware house table once every week. (truncating and loading)
This process is taking ...
3
votes
1answer
827 views
How to connect multiple users/schemas in Oracle 11g?
I'm almost new user to databases, so I think I'm doing something wrong.
I have the database created.
I created 3 users, 1 it's an Admin, 2 are just users.
I created 2 roles, 1 for the Admin and 2 ...
3
votes
2answers
219 views
SQL ANSI JOIN precedence
I have a query that looks like this:
SELECT *
FROM TBLA A
LEFT JOIN TBLB B ON A.Col1 = B.Col2
RIGHT JOIN TBLC C ON B.Col3 = C.Col4
JOIN TBLD D ON C.Col5 = D.Col6
In which order ...
1
vote
3answers
226 views
Same query taking 0.2 sec in Oracle database but 4 mins in SQL Server
SELECT A.Field1 FROM Table1 A INNER JOIN Table1 B
ON A.Field2 = B.Field2
AND A.Field3 = B.Field3
AND A.Field4 = B.Field4
AND B.Field1 = "string1"
AND B.Field2 = "string2"
AND A.Field5 = (SELECT ...
6
votes
2answers
990 views
For absolute performance, is SUM faster or COUNT?
This relates to counting the number of records that match a certain condition, e.g. invoice amount > $100.
I tend to prefer
COUNT(CASE WHEN invoice_amount > 100 THEN 1 END)
However, this is ...
1
vote
2answers
201 views
Synchronising SQL tables in two locations
have a bit of conundrum a the minute.
ANSI sql solutions please.
We have two databases located at two different geographic locations and will be using the web for all traffic between the two ...
1
vote
2answers
391 views
Moving data from Oracle to SQL Server : Table size optimization
I am loading data using SSIS from Oracle to an SQL Server database. One table I moved had a size of 4 MB under Oracle but when loaded to SQL Server, the size grows to 7.96 MB!
I analyzed the size ...
2
votes
1answer
88 views
Oracle With Statement and Delete Together
I am trying to use WITH statement and DELETE together. But I get ORA-00928 error.
Basically my code is like following
WITH TO_DELETE
AS
(
SELECT TableKey
FROM SOME_TABLE
WHERE SomeConditions LIKE ...
2
votes
2answers
1k views
What is the easiest way to move data from Oracle to SQL Server?
One of our products supports both Oracle and SQL Server as database backend. We have a customer who wishes to switch from an Oracle backend to Microsoft SQL Server, which isn't a typical transition ...
4
votes
2answers
2k views
SQL Server Express vs. Oracle Express Edition vs DB2 Express-C
I have been trying to compare the features of the SQL Server Express, Oracle XE and DB2 Express-C, but find it difficult to compile all the differences into one place. Especially the current ...
1
vote
4answers
371 views
Backup and restore of RDBMS(Oracle, DB2, SQL Server) from Perl
What could be the best approach ?
Till now could figure out the following (Oracle)
Calling exp.exe and imp.exe utilities in Oracle client using Java and inturn call it from Perl.
Calling exp.exe ...
-3
votes
1answer
208 views
Single query to copy data from 3 tables into a single empty table
In an interview today, I was asked if I could write a single query to copy data from 3 source tables to an empty destination table.
I started saying "I will use a temp table or table variables", ...
5
votes
1answer
171 views
SQL Server Linked server query problem (group by)
I have been using an old SQL Server 2000 installation for a long time that is linked to several Oracle servers, and it all works very well.
I am trying to migrate to SQL Server 2012 via SQL Server ...
0
votes
3answers
344 views
Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?
I'm sorry it may sound stupid but I've been wondering about how multiple databases are automated before the virtualization era. Can a DB Adminsitrator make a stored procedure to get data from a remote ...
-1
votes
1answer
71 views
Index Proposals
As a theoretical database question, if you are asked 'which indexes would you propose and why?' are the answers from primary, clustering and secondary index? How would we know if we should introduce ...
1
vote
1answer
186 views
How to sync a table between oracle and sybase
I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source)
I cannot truncate and populate the table in Sybase because it is used by an application, I ...
0
votes
1answer
212 views
Tools for synchronizing database schema with Oracle, SQL-Server and Netezza databases
I'm looking for software tools to move database schema for Oracle, SQL Server and Netezza. We use Oracle for our ODS, Netezza for our Data Warehouse (for it's bulk loading capabilities) and SQL ...
4
votes
3answers
254 views
How to store many smallish time-series in a relational DB?
Input Data
Multiple Tests Beds generate measurement data of various complexity.
In it's most basic form, not considering any meta-data, one measurement on a Test Bed will be a small (1 - a few ...
3
votes
1answer
299 views
SQL Server to Oracle Export - Data conversion error
I have a rather weird problem with exporting a bunch of tables from SQL Server 2005 to Oracle database. I have SQL Agent job that deletes Oracle tables, recreates them and then exports the data using ...
-1
votes
1answer
263 views
Important distinctions between DBMSs [closed]
DBA is a career I'm strongly considering after school, but my limited experience mostly involves some PL/SQL Oracle web programming, some basic PHP/MySQL web pages, and some queries in SQL Server. ...
15
votes
2answers
828 views
As a DBA, how would I go about transitioning from Oracle to SQL Server?
I'm an Oracle DBA that also has Sybase experience.
What are the major architectural and conceptual differences between the two RDBMS platforms?
An answer similar to the SQl Server->Oracle question ...
0
votes
2answers
284 views
Commercial database systems versus open source database systems [closed]
Can anyone tell me what are the reasons for buying a commercial database system and not using an open-source free version?
The reason for my question is that:
Commercial systems cost upwards of ...
8
votes
3answers
3k views
Where can I find example databases for MySQL, SQL Server and Oracle?
I want to experiment with the 3 large database management systems.
For this purpose it would be cool to have the same database (the same tables, etc.) for each of those.
Where can I find sql scripts ...
1
vote
1answer
91 views
Is it possible to schedule table update/refresh in Oracle Application Express?
I have SQL Server data dumped into a text or csv file available via HTTP. Is is possible to schedule Apex to create a table on that data and keep it updated? How?
1
vote
1answer
302 views
Get statistics of open connection to linked servers
How can I get information about connections from my MS SQL 2008 server to linked servers (actually it's an Oracle db)?
Things like number of currently open connections, and history of opened and ...
3
votes
1answer
336 views
How can I execute multiple DDL statements within a transaction in Oracle?
Is it possible to execute multiple DDL statements under a single transaction with Oracle database (10g etc.?) What I'm trying to accomplish is some sort of "upgrade" functionality of the database ...
0
votes
1answer
282 views
which DBMS should i go for? [closed]
I am interested in learning a DBMS. As a beginner which DBMS should i go for ?
I know few DBMS by name like Oracle,Sql Server,My Sql . How are these DBMS different from each other ?
As a beginner ...
14
votes
2answers
1k views
How to make a transition from SQL Server DBA to Oracle?
As an interest, if I would to transition from a SQL Server DBA to Oracle what will be the major learning or unlearning that I would have to do?
I would assume the concepts are the same and the ...
5
votes
2answers
161 views
How the indexes are managed?
I am trying to understand how the indexes are managed for below common data types:
1- Numeric (Integer, Decimals)
2- String (Varchar, Char)
3- DateTime
I have few questions:
1- How the indexes are ...
4
votes
1answer
510 views
What is Sql Server Clustered Index in Oracle terminology
A clustered index in sql server like a dictionary or telephone directory. A,B,C,D it goes on.
If you look up with a name Ozgur you start O then z etc.
I would like a simple explaination for this ...
2
votes
2answers
93 views
State of the art self healing and self protection in DBMS
At the moment I'm writing a paper and I need some input about the state of the art of self healing and self protection in DBMSs. Does somebody read some interesting articles or books about this topics ...
0
votes
2answers
124 views
How to find equivalent of Oracle's privileges in SQL Server?
I have a user in Oracle for which the permissions given are CONNECT and SELECT_CATALOG_ROLE.
How do you find the equivalents when setting up a similar user in SQL Server?
6
votes
5answers
2k views
Auto-Commit in SQL Server and Oracle
When I worked on Oracle 8 many years before, I used to execute COMMIT command manually after each bulk INSERT. In SQL Server, Auto-Commit is ON by default which has advantages as well as hazards.
I ...
3
votes
1answer
395 views
Will {fn concat} work without issue in MySQL, SQL Server and Oracle?
According to this (quite old) article the principle behind ODBC escape sequences is that
The ODBC driver reads the escape sequence and translates it into the
DBMS-specific syntax before sending ...
0
votes
1answer
503 views
32-bit versus 64-bit ODP.NET to Oracle connection
I seem to be having an issue connecting a 32-bit .NET application to a 64-bit server, without a full Oracle client.
If I build a 64-bit application, using the 64-bit ODP.NET dll's or a 64-bit instant ...
6
votes
3answers
298 views
Is there a need to keep refreshing the indexes from time-to-time?
This question is common for all the database products I use, viz. SQL Server, MySQL, Oracle and PostgreSQL.
I have created a fresh database and the tables, at present, have no records. I have created ...
2
votes
2answers
163 views
What is an industry standard method for verifying openquery connection is open prior to running queries?
I'm a programmer, but this question is more specifically related to databases so I'm posting it among this community. It could very well cross over into stackoverflow as well.
I'm seeking an ...
