User profile for Michelle T

That means that one of our queries came back with an unexpected NULL in it. Databases in the kind of state which commonly causes this problem can often be used normally with no visible problems, but may have something corrupted underneath. Or, it could be some problem with our query we haven't found yet. If you could run SQL Server Profiler on that instance, perform the comparison, and look for the last query generated by SQL Compare, then send that query and the results of that query run against that database to support@red-gate.com, we should be able to work out what went wrong with our query (or suggest further troubleshooting steps). If you can't send the results of the query for any reason, an indication of where NULL values appear in the query results will be equally useful. / comments

That means that one of our queries came back with an unexpected NULL in it. Databases in the kind of state which commonly causes this problem can often be used normally with no visible problems, bu...

0 votes

It sounds like the problem here is in accessing the backup file itself. Can you read the backup file with other programs? / comments

It sounds like the problem here is in accessing the backup file itself. Can you read the backup file with other programs?

0 votes

To work around this for the time being, you could select 'Custom Program' in Application Options and point that at Management Studio, passing it only the script file name. This is a little fiddly and is application-wide rather than project-based, but might help for the moment [image] . / comments

To work around this for the time being, you could select 'Custom Program' in Application Options and point that at Management Studio, passing it only the script file name. This is a little fiddly a...

0 votes

The differences are ignored in the main comparison, they just show up on the side-by-side view. We have long-term plans to fix the side-by-side view on this issue, but so far worries about the performance impact have stopped us doing it. / comments

The differences are ignored in the main comparison, they just show up on the side-by-side view. We have long-term plans to fix the side-by-side view on this issue, but so far worries about the perf...

0 votes

We're unlikely to change object text due to Ignore options or automatically refactor your objects for you in this version because we're still a bit paranoid about things that could accidentally mess with your objects in ways you might not be expecting. We're getting more confident in this area since the sp_rename fix went down okay, though, so we might consider it in the future. We're still working on the 'export a data source' dialog, but there are unlikely to be any major functionality change in this version (like automatically overwriting / creating a folder for a database). That save dialog *should* be defaulting to your My Documents directory, in fact it is doing so on my VM. Do you have any weirdness in how your profile is set up (roaming profiles, anything like that)? The 'click + to - only' thing makes me think you might have run across the reporting 'issue' where the reports have always only exported selected objects, but we used to default to everything selected and now we default to everything deselected. Our usability people are thinking about how to fix that confusion. Is that it? (You can tell due to the number of objects the header tells you should be in that group.) SQL Compare now deals with some system objects (because people were putting custom permissions on them, changing their owners/schemas, putting them in roles etc etc, and wanted to see and synchronize those changes), which may be why you have got more system objects showing in your database than previously. It should be mostly users and schemas though - I haven't seen any dt_ stored procedures or system views in my databases. What version of SQL Server are the databases on where you're suffering these problems, does it happen on all databases of this version, and are the views / SPs customised in any way? (I haven't just ignored your rules questions - I just don't have any immediate answers. We'll discuss the issues but we've been trying to keep the rules and filteres interface as simple as possible because we think most people will have fairly simple use cases and don't want to confuse them with more features.) / comments

We're unlikely to change object text due to Ignore options or automatically refactor your objects for you in this version because we're still a bit paranoid about things that could accidentally mes...

0 votes

We did remove the feature intentionally - it caused occasional problems (people finding it harder to understand which database was going to change, the reverse direction synchronization sometimes not dealing with server versions correctly) and was quite expensive to maintain as we changed the user interface, and as you say we didn't think many people were actually using it [image] . We're working on a way to let you switch data sources without re-registering the database (not to switch directions, but to swap the data sources without going back to Edit Project), and your feedback that you actually use the old functionality will give that work a higher priority, although I obviously can't promise you it'll get in. / comments

We did remove the feature intentionally - it caused occasional problems (people finding it harder to understand which database was going to change, the reverse direction synchronization sometimes n...

0 votes

Which dialogs have flat buttons for you? We do use a mixture of standard and third-party controls, and some of the latter might have changed the button style under some circumstances. Also, what operating system (and 'theme' if applicable, e.g. WinXP, Classic, Aero) are you using? I spotted the other one (resize cursors on Edit Project) during testing and it's filed in our system, but we haven't got around to fixing it yet. The error is that the resize cursors show up at all - we don't intend the dialog to be resizable. Is this a problem for you? / comments

Which dialogs have flat buttons for you? We do use a mixture of standard and third-party controls, and some of the latter might have changed the button style under some circumstances. Also, what op...

0 votes

:oops: Thank you for your kind reports, the bug that SQL Compare is defaulting to 'Custom program' rather than one of the other options if available is now filed as SC-4232 and should hopefully get fixed before the final version goes out [image] . / comments

:oops: Thank you for your kind reports, the bug that SQL Compare is defaulting to 'Custom program' rather than one of the other options if available is now filed as SC-4232 and should hopefully get...

0 votes

If you go to Application Options on the Tools menu, or click on the Edit... link after the box with 'isqlw.exe' in it, there are radio buttons on the resulting dialog. Are the ones for SQL Server 2005 Management Studio and SQL Server 2008 Management Studio enabled or disabled? (I'm asking this because we've changed how we're detecting if you have these programs installed, and I'm worried that your copy of the Beta might not be picking up correctly that these programs are installed, hence defaulting to 'Custom Program' instead of one of these options.) / comments

If you go to Application Options on the Tools menu, or click on the Edit... link after the box with 'isqlw.exe' in it, there are radio buttons on the resulting dialog. Are the ones for SQL Server 2...

0 votes

The default 'custom program' example is actually Query Analyzer (that came with SQL Server 2000), not SQL Server Management Studio. So if you'd selected 'custom program' and don't have QA installed, it will fail to find it. Application options should have defaulted to selecting the 2008 version of SSMS for you, though. Could you go to the Application Options dialog and check that the 2005 and 2008 SSMS radio buttons are enabled? / comments

The default 'custom program' example is actually Query Analyzer (that came with SQL Server 2000), not SQL Server Management Studio. So if you'd selected 'custom program' and don't have QA installed...

0 votes

How can we help you today?

Michelle T

Comments