Category: SQL Server

18 Sep 2016 10:52

Joined:	19/05/2015
Level:	Silver
Points:	101

Points:	3

EveryDay data copy from one sql server to another sql server

Hi Team

I would like to copy data everyday 4:00AM from one sql server to another sql server

1)creating a new windows service to copy data

2)source sql will send data in the form of a text file and placed in a location from where the data can be loaded to the LCT ASH SQL DB.

Let me know which is best (1 or 2)and can be done in less time.

and what are the requirements for 2nd one.

#767864

20 Sep 2016 00:16

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	4

We can easily schedule in your Sql Server itself. Our requirement is moving values from one table server to another table server.

First Schedule the Job in your first server that is where you gonna extract the data and stored it.
Below are the steps for the SQL Job Scheduling.

1. Expand the SQL Server Agent node and right click the Jobs node in SQL Server Agent and select 'New Job'

2. In the 'New Job' window enter the name of the job and a description on the 'General' tab.

3.Select 'Steps' on the left hand side of the window and click 'New' at the bottom.

4.In the 'Steps' window enter a step name and select the database you want the query to run against.

5.Paste in the T-SQL command you want to run into the Command window and click 'OK'.

6.Click on the 'Schedule' menu on the left of the New Job window and enter the schedule information (e.g. daily and a time).

7.Click 'OK' - and that should be it.

Once this Setup is done. Step 5 We need to insert the code.
Use the below code in the specify area.


SELECT * 
INTO [destination server].[destination database].[dbo].[destination table] 
FROM [source server].[source database].[dbo].[source table]

Thanks,
Mani

#767873

20 Sep 2016 02:38

Joined:	19/05/2015
Level:	Silver
Points:	101

Points:	1

Hi Mani,

Data is coming from one DB at 4:00AM and using above procedure i can schedule job at which will import data from 2nd DB 6:00AM

Will data append.??

EveryDay data copy from one sql server to another sql server

About dotnetspider.com

Quick Links

General

Services