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.
16 freelancers are bidding on average $55 for this job
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