I have an Origin Database - #1 with very restrictive access due to security.
I provisioned a new Windows desktop machine with Microsoft Sql Server Management where I created a local database with all privileges, so I can create a Linked Server to database #1.
I have access to the Database #1 via Linked Server but I need to replicate some tables in realtime; I tried using the Replication option in the Object Explorer, but it does not allow me to do anything with the Linked Server.
How can I replicate some of those tables via Linked Server? So, I can copy those tables and updates and store them in local database?