I gang

MSSQL migration Scheduled Task to another server

Hi,

I need a solution for the following:

I have a mssql database on windows 2008 r2 server, which is constantly increasing in size and is currently at 800mb. Sometimes the network crashes and the website is down and that also means the database is down as well, so i want solution for the following:

I want to copy the mssql db to another msql db on another server automatically without me having to do anything using a custom script, i know it is 800mb but i do not have the time to manually backup the db and transfer on a daily basis. The task is that all the tables to copy to another db and most likely this needs to be done with custom script on scheduled tasks (cron).

all our tables have an identity field, in the source database table keep the same identity number.

Example if a table has a number called 555, the target destination table should contain the same number and data of that particular row/source.

First time we need to transfer all tables, the second time onwards we need to be able to edit the script to choose which table to transfer. Also we want be able to choose date and time of when we want to backup and transfer.

Færdigheder: Database Administration, Programmering af database, SQL, Windows Server

Se mere: mssql having, mssql, c# MSSQL, daily task, windows server task server, server 2008 scheduled task, scheduled, backup mssql, sql database size, transfer cron server, windows 2008 server migration, windows migration, task network, network migration, database mssql, backup sql script, migration tables, sql migration, database msql, network programming task, windows script windows 2008, scheduled backup, cron backup, mssql database, transfer sql

Om arbejdsgiveren:
( 135 bedømmelser ) Celtic, United Kingdom

Projekt-ID: #6054274

Tildelt til:

sumon355

Hello, I am very much interested to do this work as i am experienced a lot in database related works. I also did similar type of works like taking automated db backup, move to another server etc. I can do your work by Mere

$40 USD på 1 dag
(13 bedømmelser)
3.5

16 freelancere byder i gennemsnit $55 for dette job

marasinghe82

Dear Sir Please assign this task for me I can assure 100% completion. I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, Mere

$45 USD på 1 dag
(60 bedømmelser)
5.5
kultech

Dear Sir, I think we can using trigger or using C# create winservices run by your time setup. Happy working with you. Thank You

$55 USD på 1 dag
(5 bedømmelser)
4.4
karunakartiwari

Hello Sir, I am Working with Data Center Organization as a Linux and windows Expert, I have more than 8 years’ experience in Web hosting and migration, working on more than 1000 of Linux and Windows servers. I will Mere

$50 USD in 2 dage
(17 bedømmelser)
4.5
sflogics

Hi, We’ve had a good look at your project description and we’re very interested in providing a solution. We are a professional development company head-quartered in Pakistan. If you like what you see and if our qu Mere

$100 USD på 1 dag
(3 bedømmelser)
4.0
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Mere

$157 USD in 3 dage
(7 bedømmelser)
3.8
acronymsolutions

Hi, I have gone through your requirements.I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL Server,SQL Server(2005,2008,2010,2012)Oracle database, I can do your job confidently. I am very muc Mere

$49 USD på 1 dag
(10 bedømmelser)
3.8
amiteshojha

Hello Sir, I am Working with 3 tier Data Center Organization as a MSSQL server Expert, I have more than 5 years experience in,MSSQL Server Setup, Configuration, troubleshooting, Security, Web security, Web hosting,Data Mere

$50 USD på 1 dag
(7 bedømmelser)
3.6
rsmusthafa

Hello, I can create script to make it run on scheduled tasks to copy from 1 mssql db to another db Regards Musthafa

$83 USD in 2 dage
(2 bedømmelser)
2.9
shanalalkasim

Hi, My name is shanalal kasim. I have 7yr experience in sql server. My current project database is 50 GB we are handling this smoothly, so I can handle your issue. I am revising my proposal I can create an ap Mere

$83 USD på 1 dag
(2 bedømmelser)
2.9
mahesagrimba

Hi, I propose to use sql server scheduller. Or if it is not possible in your environment, I can create a .net service to do that. Let me know detail of your table. Regards

$55 USD på 1 dag
(2 bedømmelser)
1.9
alokmh76

I am a new freelancer having over 15 years of professional exp on wide ranging technologies & databases. I have worked on realtime replication of database for a client to resolve the response issue of the high traffic Mere

$25 USD på 1 dag
(0 bedømmelser)
0.0
VNDotNetWorker

I am Bien Chu from Ericsson Vietnam skype: biench82 I have some similar tasks like this. Give me this task. CHU HAI BIEN HANOI UNIVERSITY OF TECHNOLOGY, VIETNAM Master of Mathematics and Informatics MICROSOFT Mere

$25 USD på 1 dag
(0 bedømmelser)
0.0
Nithinkumar83

A proposal has not yet been provided

$25 USD in 4 dage
(0 bedømmelser)
0.0
azadhussainster

I already have a custom vb.net based console application running that just does what you want. I just need to schedule it in Task scheduler and set a scheduled backup through SQL agent. The program can restore the data Mere

$20 USD på 1 dag
(0 bedømmelser)
0.0
gauravarora1983

A proposal has not yet been provided

$25 USD på 1 dag
(0 bedømmelser)
0.0