SQL Migration script

In Progress Posted May 10, 2013 Paid on delivery
In Progress Paid on delivery

I wanted to have 3 Stored Procedures written:

1. Create Migration scripts - Backup & Restore

We are migrating some SQL Servers and I need a stored procedure which will:

1. Backup databases from source to a disk destination

2. Restore the databases to destination server

3. Populate an Audit table with what was backed up and restored.

Something like...

CREATE proc [usp_DX_RestoreDBs]

@SourceServerName varchar(50)='amazona-6s24rum',

@DestinationServerName varchar(50)='amazona-6s24rum',

@SourceDBName varchar(50)='DXMigration',

@DestinationDBName varchar(50)='DXMigration',

@BackupFilePath varchar(200)='C:\DXMigration\Phase 1\OUT\'

2. Migrate SQL Jobs

3. Migrate LinkedServers

Please quote for these 3 scripts.

Thanks

Database Administration SQL

Project ID: #4508598

About the project

10 proposals Remote project Active May 11, 2013

10 freelancers are bidding on average $153 for this job

MMaghawry

I'm Professional in SQL Server ,so I can do these store procedures , as I already did it here in my SQL DB servers.

$155 USD in 3 days
(73 Reviews)
6.2
feninsoftech

Hi, I have 8 years experience in SQL Server development. I have experience in this type of activities.

$177 USD in 3 days
(37 Reviews)
6.0
vhrios

Hi Sir, I'm a expert SQL Server, TSQL and DBA. I can do it! Thanks in advance!

$111 USD in 2 days
(5 Reviews)
3.8
daveclary

I am a 20-year veteran SQL Database Administrator and can build this script for you quickly and efficiently. It would take very little time to write. I have written similar backup/restore migration scripts in the past. More

$111 USD in 1 day
(7 Reviews)
4.0
sadeque

have more then 8 years of experience on ms sql server. Lets start ...

$111 USD in 3 days
(12 Reviews)
4.4
vw991322vw

Hi, Am a SQL Server expert. I can get this script written for you at the earliest. Please contact me for further details.

$133 USD in 2 days
(1 Review)
2.2
suniljainmca2011

I am very good at sql server 2008/R2. I can create these scripts.

$222 USD in 1 day
(0 Reviews)
0.0
vuyiswamaseko

I can do that for you. Experienced.

$155 USD in 2 days
(0 Reviews)
0.0
colmanm

y am ready for work

$244 USD in 9 days
(0 Reviews)
0.0
sachit27

I have more than 10 years of experience with SQL Server. I could help if required.

$111 USD in 3 days
(0 Reviews)
0.0