176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Convert Oracle scripts to SQL Server scripts
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jan 16, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sat, Jan 14, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Convert several Oracle functions (provided) for use in SQL Server.
USE [DW_USER]
GO

/****** Object: UserDefinedFunction [dbo].[GET_DATES] Script Date: 01/14/2012 18:52:56 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION [dbo].[GET_DATES]
(
)
RETURNS varchar(8000)
AS
/*Generated by SQL Server Migration Assistant for Oracle version 5.1.1106.*/
BEGIN

DECLARE
@active_spid INT,
@login_time DATETIME

SET @active_spid = sysdb.ssma_oracle.GET_ACTIVE_SPID()

SET @login_time = sysdb.ssma_oracle.GET_ACTIVE_LOGIN_TIME()

DECLARE
@return_value_argument varchar(8000)

/*
* SSMA warning messages:
* O2SS0452: "xp_ora2ms_exec2_ex" when called from within UDF cannot bind to outer transaction. It can lead to dead locks and losing transaction atomicity. Consider calling $impl procedure directly.
*/

EXECUTE master.dbo.xp_ora2ms_exec2_ex
@active_spid,
@login_...

Sign in or Register to see more

Job ID: 28086999
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
18 years of Web and Database Systems experience among several technologies including Microsoft, Java, Oracle, GIS and Autocad based projects.
9
  |  
 5.0   |  $25,719 Earnings   |  12 Jobs
Bid ID: 28115875  |  Submitted: Jan 16, 2012 15:23 ET 
Proposal SEALED

 India  |  
Oracle Certified Professional in SQL/PLSQL and SOA Experienced and passionate Coder who follows the idea of great quality work with minimum...
4
  |  
 4.4   |  Private   |  1 Jobs
Bid ID: 28100256  |  Submitted: Jan 16, 2012 00:03 ET 
Proposal SEALED

 India  |  
Team of Business Intelligence ,Cloud Computing and Big Data Architects with deep finance domain knowledge and top-class implementation experience...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 28094498  |  Submitted: Jan 15, 2012 13:12 ET 
Proposal SEALED

 Russia  |  
My name is Elena. I'm a professional software developer living in Moscow, Russia. I have total 8+ years of experience in software development and...
1
  |  
 0.0   |  $910 Earnings   |  0 Jobs
Bid ID: 28089126  |  Submitted: Jan 15, 2012 01:08 ET 
Proposal SEALED

 Jamaica  |  
The creation of solutions is the reason that I exist. You are guaranteed quality with a reasonable price. Backing up those statements are my twenty...
6
  |  
 5.0   |  Private   |  13 Jobs   |  1 verified credential(s)
Bid ID: 28087376  |  Submitted: Jan 14, 2012 20:04 ET 
Proposal SEALED

 Greece  |  
BH Cloud force Inc established in May 2014 with primary goal to develop Business and BI solutions based on Microsoft Technologies and Microsoft...
9
  |  
 4.9   |  Private   |  29 Jobs   |  1 verified credential(s)
Bid ID: 28087208  |  Submitted: Jan 14, 2012 19:39 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »