Find Jobs
Hire Freelancers

Database migration scripts for Azure

$30-250 CAD

In Progress
Posted about 8 years ago

$30-250 CAD

Paid on delivery
I need a powershell script that will perform some simple operations: 1- download all databases from a sql server in Azure to local storage in a bacpac format 2- upload all these databases from step 1 to my local sql server instance. It must remove the database from my local sql server if it previously existed. 3- export databases from my local sql server instance to Azure SQL server (first removing the one already existing with the same name). I need to be able to run step 1 and 2 in one pass. Then I need to be able to run step 3 separately. Need a config file that will be read by the powershell script that will contain credentials (i.e. Azure Login, Password, Azure Subscription Id, Server Login, Password, Local SQL Server credentials, etc.). As part of the config file, the folder for the local storage of the bacpac should be included. I do not want to be prompted for the credentials. For step 3, The database names to be uploaded will need to be in the config file and their corresponding name in Azure will also need to be in the config file. (i.e. Name on local sql instance is NewDB001 and the name once uploaded to Azure needs to be DB001). Note that there needs to be a variable number of databases to upload. Need all steps to contain error handling and all activities need to be logged to a log file, which should be the same as the folder for local storage. If required for step 1, a temporary Azure blob storage can be used. If used, the credentials and info should be stored in the config file and all data should be removed once downloaded.
Project ID: 10071879

About the project

2 proposals
Remote project
Active 8 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
More then 20 years of experience in programming and databases. I graduated in Computer Science and Electrical Engineering (University of Belgrade, School of Electrical Engineering). Excellent knowledge and experience of c#, c++, SQL, .NET, Java, Azure, MS SQL server, MySQL, PostgreSQL, MS Access, VBA ...
$55 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
2 freelancers are bidding on average $140 CAD for this job
User Avatar
I have experience in Azure PowerShell scripts and I can do it fast. I can work at night / early morning to minimize downtime.
$225 CAD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Brossard, Canada
5.0
4
Payment method verified
Member since Oct 25, 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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.