Tag: oracle

Entity Framework with Multiple DB Engines

We have a few .Net application that we would like to start using Entity Framework 5.0 but the problem is that our customers can choose to use one of any of the following database engines: SQL Server (95% of Customers use this engine) Oracle (3% use this engine) DB2 (2%) So as you can see […]

How to connect to Oracle db from SSIS/SQL Server Data Tools?

I have Oracle 11g r2 client installed on my 64 bit machine running Windows Server 2008 r2. Have the following installed: SQL Server 64 bit MS Office 64 bit I tried connecting from excel/powerpivot to the oracle db, it works perfectly fine. However, when I try to connect from SSIS to the Oracle db, I […]

SQL Server equivalent in Oracle

I’m new in Oracle database. What I need is equivalent query in Oracle like this example from SQL Server (reading results in Management Studio). On Oracle side, I’m using Golden6 from Benthic Software. declare @n integer set @n = 100; select * from table where id >= @n and id <= @n + 50 Thank […]

Analog of OUTER APPLY in other RDBMS (not SQL Server)

I’m using SQL Server at work, and I have some nice tricks with OUTER APPLY clause which helps me do not repeat code. For example, if I have a table like this: create table Transactions ( ID bigint identity(1, 1) primary key, [Date] datetime, Amount decimal(29, 2), Amount2 decimal(29, 2) ) insert into Transactions ([Date], […]

SQL Server Migration Assistant for Oracle truncating text at 100 chars

I’ve been trying unsuccessfully to migrate an oracle database to sql server 2005. The problem I’m seeing is with migration of Oracle “LONG” text to SQL varchar. I only get the first 100 characters of data from the field I’m checking in the Oracle database after the migration completes. I can see data past 100 […]

Export Users, roles and grants into a CSV file

I need to extract the users into CSV file and upload it into the role modeller to design an effective security model. Now the question arises how do I export users, roles and grants into a CSV files on MS SQL and Oracle?

Optimistic Concurrency in Entity Framework between Oracle and T-SQL

I am building EF Code first POCOs that’ll be used between an Oracle back-end and a MS SQL Server backend. I’m having a problem finding the right way to tackle a Timestamp property that’ll work on either database back-end. MS SQL Server would have me use a common property like this: 1506510036 public byte[] Timestamp […]

Entity Framework : Schema specified is not valid

I am developing a web application that is using Entity Freamwork 5 Visual Studio 2012 and it need to support both SQL Server and Oracle database providers. I created entity model for Oracle Database. I thought it would work after some changes in connectionstrings, bu no it is not that easy .. I found this […]

Retrieve only distinct combinations

I’m having column as Node varchar(25) in MS-SQL Server. The possible values are node —– D-C C-B B-A B-C B-E C-A A-B A-C C-D etc. I want to retrieve the the distinct combinations from it. E.g.: node —- D-C C-B B-A B-E C-A Please tell the SQL for this.

How can I use Dapper in a multi database environment?

I’m trying to implement simple queries like SELECT * FROM TABLE_X WHERE XID = @id, but the problem that I’m having is that these queries would run on different databases (SQL Server and Oracle) for different application instances. How to do it without to have to write each database a new set of queries?

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.