I have two databases on an online website hosting. but some how i need to copy some of the records from on database to another, for more processing etc. on my local pc i could simplye query it as
insert into database2.schema.table
select * from database1.schema.table,
but on online server that is not possible because of security issues. i googled and found these commands
exec sp_addlinkedserver @Server='myserver',
@srvproduct = '', @provider = 'SQLNCLI', @catalog = 'catalogname' ;
EXEC sp_addlinkedsrvlogin @rmtsrvname='myserver',
@useself='false',
@rmtuser='username',
@rmtpassword='password';
but i dont have enough permissions to execute it online, so
is there any other way to access a database from another database?
PS: the second database is like an IMAGE DATA TABLE for temporary records management, first it copies records from first database after changes and work out etc, it will be writing it back to first database, My goal is to write SQL procedures which can select/write records from/to first database to second database.