Find Jobs
Hire Freelancers

Database migration scripts for Azure

$30-250 CAD

Berlangsung
Dibuat sekitar 8 tahun yang lalu

$30-250 CAD

Dibayar ketika dikirim
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.
ID Proyek: 10071879

Tentang proyek

2 proposal
Proyek remot
Aktif 8 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
2 freelancer menawar dengan rata-rata $140 CAD untuk pekerjaan ini
Avatar Pengguna
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 dalam 3 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera CANADA
Brossard, Canada
5,0
4
Memverifikasi Metode pembayaran
Anggota sejak Okt 25, 2014

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.