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:
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]
so how would I change the setup for the FROM ..... to connect to a different database on a different server
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.