Link to home
Start Free TrialLog in
Avatar of Tagom
Tagom

asked on

how to code transerfering data from one database table to another when on different servers

I am unsure of how to code transferring data from one table in one database to another when on the same network but different server
ex:
INSERT INTO [acisql2].[dbo].[OPIS_LOGS]
           ([OPISLOG_KEY]
           ,[OPISLOG_PRMTLINK]
           ,[OPISLOG_PRMT]
           ,[OPISLOG_TIMESTAMP]
           ,[OPISLOG_UCODE])
     SELECT
           [OPISLOG_KEY]
           ,[OPISLOG_PRMTLINK]
           ,[OPISLOG_PRMT]
           ,[OPISLOG_TIMESTAMP]
           ,[OPISLOG_UCODE]
FROM [JasperTest].[dbo].[OPIS_LOGS]

Open in new window

so how would I change the setup for the FROM ..... to connect to a different database on a different server
ASKER CERTIFIED SOLUTION
Avatar of rbride
rbride

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial