What are the challenges you face when working across database platforms? Take the survey

Does SQL Compare work against a db on a hosted server?

SpudSpud Posts: 23
edited April 29, 2013 9:04AM in SQL Compare Previous Versions
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


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    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.
Sign In or Register to comment.