If the answer is the right solution, please click "Accept Answer" and kindly upvote it. ![]() Note:Two servers can access the database only if they are allowed to communicate įor example, SELECT T1.ID, T1.name,T2.ID,T2.nameĢ.Two databases on different servers : exec sp_addlinkedserver 'alias','','sqloledb','ip address'Įxec sp_addlinkedsvlogin 'alias','false',null,'uesername','password' If you have access to both databases, and your table keys match, you can join across databases by specifying the fully qualified name. You can send feedback anonymously, or you can include your email address if you want us to get back to you.Īlternatively, you can continue to contact us via email ( or via our Github Issues page.The key point is that whether the two databases are on the same server. Postico will include relevant version numbers automatically, and optionally even include a screenshot of the current window. Postico now has a dedicated "Feedback" button in the toolbar to send feedback or to request support. Some databases like Vertica are supported only in a limited way: executing SQL is possible, but other features do not work. In addition to PostgreSQL, we have first class support for Amazon Redshift, Greenplum, and CockroachDB. Postico tries to support all PostgreSQL-compatible databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |