How can we help you today? How can we help you today?

Not finding some servers, some databases

I've found two problems with SQL Compare.

1. On my development computer I've got instances of SQL Server 2000, SQL Server 2005 Developer and SQL Express 2005. Only the SQL Server 2000 instance is showing in the drop-down list. Tapping in the SQL Server 2005 names causes a whole dialogue box repaint, but no databases are listed.

2. I have three sites, two on the same domain all connected by VPNs. I'm getting proper connections to SQL Server 2000 instances on the same domain, but I'm not getting a connection to the third site even when I tap in the server name (this works on earlier versions of SQL Compare).


Finally, it would be quite handy to have an option not to show the system databases in the drop-down box (master, etc).

Crispin
CrispinH
0

Comments

3 comments

Sort by
  • diegov
    I found similar behavior (perhaps the same) in the project configuration dialog. But it happened to me with an instance of SQL Server 2000.

    But then I found that once I wrote the instance name by hand, it got recognized. The database list was fetchend and since then the instance apears in the server list. I am guessing it got cached.
    diegov
    0
  • mrichmon
    A few comments...

    I have found that SQL Compare, like previous versions does not seem to recognize instances. It lists the server, but you must add in the instance notation.

    Additionally, for default instance or multi instance, when it recognizes servers that have SQL server installed on a non-standard port - it lists the server in the drop-down, but you must modify it to include the non-standard port before you click the dropdown for databases. Otherwise it takes some time to time-out before you can add in the port.

    I don't know if you can actually do anything for non-standard ports, but it seems strange that it can see that the server is a SQL server (so it must somehow look on other ports?)
    mrichmon
    0
  • mrichmon
    Also,

    After I have altereted the entry to my nonstandard port or altereted it to include the instance, the next time I go to create a new project - the drop-down menus of the servers still include the same as before - just the server name and I have to re-enter instances or re-enter non-standrad ports.

    It would be nice if it at least rememebered changes to the list that the user entered if it cannot detect that information on its own.

    Another idea (at least for the non-standard ports) is what if there was an application option that allowed you to specify the "default" port that should be examined?
    mrichmon
    0

Add comment

Please sign in to leave a comment.