Find Jobs
Hire Freelancers

Database migration scripts for Azure -- Repost

$30-250 CAD

已完成
已发布大约 8 年前

$30-250 CAD

货到付款
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. I currently have a budget of around $50 for this. You must setup you own MS Azure Test environment from which you will test the scripts before delivery.
项目 ID: 10115592

关于此项目

2提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
$70 CAD 在10天之内
0.0 (0条评论)
0.0
0.0

关于客户

CANADA的国旗
Brossard, Canada
5.0
4
付款方式已验证
会员自10月 25, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。