You must Sign In to post a response.
  • Category: SQL Server

    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
    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
    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.??


Sign In to post your comments