Is there any way to create a mssql foreign server and create foreign tables from multiple databases?
Or do I have to create different servers for each database?
I am confused by the fact that the database parameter is optional for the foreign server, and also in some older documentations there are examples with adding option database when creating a table, but I receive an error that the parameter is not valid.
If it is possible, maybe it would be useful to update the existing documentation, or specifically mention that this option is not possible :)
Hello,
Is there any way to create a mssql foreign server and create foreign tables from multiple databases? Or do I have to create different servers for each database?
I am confused by the fact that the database parameter is optional for the foreign server, and also in some older documentations there are examples with adding option database when creating a table, but I receive an error that the parameter is not valid.
If it is possible, maybe it would be useful to update the existing documentation, or specifically mention that this option is not possible :)
Thank you, Mihai