Find Jobs
Hire Freelancers

deploying sql scripts

$30-250 USD

Completed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
The DDLs don't contain any changes to tables, only view, stored procedures, and functions. The DDLs might have inter-dependencies between them, one STP that calls another, for example. I don't want to start organizing the files in the correct order, because it would take too long, and I want the entire operation to fail if any one of the scripts has an error. How can I achieve this? My idea so far, is to start a transaction, tell the SQL to ignore errors (which I don't know how to do) run all the scripts once, tell the SQL to start throwing errors again, run all the scripts again, and then commit if everything succeeds. Is this a good idea? How do I CREATE \ ALTER a stored procedure or view even though it has errors? To clarify and address some concerns... This is not intended for production. I just don't want to leave the DB I'm testing on broken. What I would like to achieve is this: run a big group of scripts on the server, without taking the time to order them. But if any of the scripts has an error in it, I want to rollback the entire operation. I don't care about isolation, I only want the operation to happen as a single transaction.
Project ID: 13730362

About the project

2 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
3-4 years building enterprise applications. I am a full stack developer with oracle plsql and microsoft sql server experience.
$155 USD in 10 days
5.0 (1 review)
2.4
2.4
2 freelancers are bidding on average $155 USD for this job
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
new york, United States
5.0
5
Payment method verified
Member since Sep 4, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.