Does SQL Compare work against a db on a hosted server?
Spud
Posts: 23
As per the title really.
When I try to compare a database on a hosted off-site server, the database dropdown does not list available databases. This I would expect - I shouldn't be able to see other clients databases, and there was a known performance issue iterating through a huge number of databases. I can only see master, and tempdb, or have the option to Create a new one. Thus far no problem - Object Explorer in SSMS does exactly the same.
*However* , it will not let me enter the name of the database(s) that I know do exist and have access- as I use them daily and can connect to them elsewhere.
Is this a known limitation of sql compare or is there something I'm not doing correctly?
Many thanks
When I try to compare a database on a hosted off-site server, the database dropdown does not list available databases. This I would expect - I shouldn't be able to see other clients databases, and there was a known performance issue iterating through a huge number of databases. I can only see master, and tempdb, or have the option to Create a new one. Thus far no problem - Object Explorer in SSMS does exactly the same.
*However* , it will not let me enter the name of the database(s) that I know do exist and have access- as I use them daily and can connect to them elsewhere.
Is this a known limitation of sql compare or is there something I'm not doing correctly?
Many thanks
Comments
Sorry to say, I can't reproduce the issue. I can type any name I need to in the database combo box by hand. Maybe it's trying to connect to the server at the time - not sure. But normally I don't see this happening.