All Questions
Tagged with oracle sql-server
31
questions
0
votes
1
answer
422
views
Time of consistency of full backup in Oracle and SQL Server
Simple situation:
Taking an online full backup of database, start at 01:00 and end at 02:00. And then restore the backup.
In my understanding:
For Oracle, if I restore the backup, everything is as ...
0
votes
1
answer
691
views
Number of Active Database Connections Performance Counters?
We are using OleDbConnection class to connect Oracle and SqlServer. At some places we are also using SqlClient and Oracle.DataAccess.OracleConnection. I need to know how many active connections our ...
1
vote
1
answer
5k
views
Reporting Services: Cannot connect to Oracle using Integrated Security
Context
I have an Oracle 11g database instance and a SQL Server 2012 instance installed on 2 different servers in the same domain. The Oracle database is configured to accept connection with ...
1
vote
1
answer
2k
views
One Way Replication of Oracle 11g to MSSQL 2008R2
We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS.
What is a good method to automate a one-way, read-only ...
6
votes
4
answers
14k
views
Why "Begin Transaction" before "Insert Query" locks the entire table?
I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with ...
1
vote
4
answers
2k
views
SQL server Vs MySql vs Oracle for a large government project [closed]
I am in charge of deciding which database to use for a big government project with:
100 Million records (estimated in one big table)
Availability and data reliability is paramount.
Performance not as ...
66
votes
7
answers
19k
views
What are the drawbacks of running a database inside a virtual machine? How do I overcome them? [closed]
Running anything inside a virtual machine will have some level of performance hit, but how much does it really impact the performance of a database system?
I found this academic reference paper with ...
2
votes
1
answer
363
views
Microsoft SQL alternative for Oracle's Imp and Exp command
I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases.
Any suggestions?
0
votes
2
answers
1k
views
Microsoft SQL alternative for Oracle's Imp and Exp command [duplicate]
Possible Duplicate:
Microsoft SQL alternative for Oracle's Imp and Exp command
I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp ...
1
vote
1
answer
6k
views
MS SQL 2008 - Setup Oracle Linked Server [SERVICE_NAME not given error]
I'm trying to setup a linked server on MS SQL 2008 R2 to an Oracle 11g server. I've got the Oracle client installed and sqlnet.ora, tnsnames.ora & listener.ora copied from the server and in place ...
0
votes
1
answer
555
views
Does Oracle DB has a tool like DTS Wizard in SQL Server?
Is there a tool like the Microsoft SQL Server's DTS (Data Transformation Services) Wizard that simplifies the process of ad-hoc importing of flat files (CSV, TSV, or XLS) to Oracle database?
...
1
vote
4
answers
117
views
Requesting Oracle DBA to use SCSI instead of IDE
We want to improve the performance of our oracle database which stores around 10 TB and is OLTP.
I noted that the Oracle server uses IDE hard drive, and have heard that SCSI is faster than IDE. Will ...
1
vote
1
answer
5k
views
Unable to access Oracle DB from SQL Server with ODAC?
I've downloaded and install the ODAC for connecting oracle DB into my SQL Server 2008 using http://download.oracle.com/otn/other/ole-oo4o/ODAC112021Xcopy_x64.zip
The OleDB data provider for Oracle ...
1
vote
4
answers
126
views
Database security
What aspects should be considered in order to have a secure database?
Along with avoiding sqlInjection, what else should be considered? What should not be done?
2
votes
3
answers
143
views
Moving database from SQL Server 2005 to Oracle DB
What would be the easiest way to migrate a database that I have in SQL Server 2005 to Oracle? I have around 6 tables each with a large amount of data in it.