Find Jobs
Hire Freelancers

Database migration scripts for Azure

$30-250 CAD

En curso
Publicado hace alrededor de 8 años

$30-250 CAD

Pagado a la entrega
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 del proyecto: 10071879

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
2 freelancers están ofertando un promedio de $140 CAD por este trabajo
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Brossard, Canada
5,0
4
Forma de pago verificada
Miembro desde oct 25, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.