Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT OPENQUERY (ORTEST, 'SELECT * FROM reservation')
- VALUES (2, '2', 3);
- INSERT INTO ORTEST.[dbname].[dbo].[reservation]
- SELECT * from [dbname].[db].[reservation]
- exec master.dbo.sp_MSset_oledb_prop 'ORAOLEDB.Oracle', N'AllowInProcess', 1
- go
- exec sp_addlinkedserver @server = 'MyOracleServer', @srvproduct = 'Oracle', @provider = 'OraOLEDB.Oracle', @datasrc = 'MyOracleLinkedServer'
- go
- exec master.dbo.sp_serveroption @server=N'MyOracleServer', @optname=N'rpc out', @optvalue=N'true'
- go
- sp_addlinkedsrvlogin @rmtsrvname = 'N'MyOracleServer', @useself = 'false', @locallogin = NULL, @rmtuser = 'myRemoteUser', @rmtpassword ='myRemotePassword'
- go
- insert into [MyOracleServer]..[MyRemoteSchema].[MyRemoteTable](
- [MyRemoteField1],
- [MyRemoteField2]
- )
- select
- t.Field1,
- t.Field2
- from
- [dbo].[MyLocalTable] as t
Add Comment
Please, Sign In to add comment