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 […]
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 […]
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 […]
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], […]
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 […]
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?
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 […]
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 […]
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.
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?