Comments
Sort by recent activity
Hi there - I don't know of any reason that SQL Compare 10 would be broken on Windows 10, so it might be worth trying to see how it works. However, we definitely support Windows 10 in SQL Compare 11 and 12 (based on the requirements docs here) so I would suggest you upgrade to SQL Compare 12 as that's the currently supported version. / comments
Hi there - I don't know of any reason that SQL Compare 10 would be broken on Windows 10, so it might be worth trying to see how it works. However, we definitely support Windows 10 in SQL Compare 1...
You're right, that is something that SQL Compare should be able to handle. I've just done some quick tests with views and I haven't been able to reproduce the problem, so it might be a bug with your specific reproduction. Some more information about the views in question would be helpful - you can getting in touch with support if you want to keep database details private / comments
You're right, that is something that SQL Compare should be able to handle. I've just done some quick tests with views and I haven't been able to reproduce the problem, so it might be a bug with you...
In the meantime we'd be really interested if anyone else is hitting a similar issue - this sounds like a pretty serious bug, so we'd like to get it fixed as soon as possible before pushing 12.3 out from Frequent Updates to everyone. / comments
In the meantime we'd be really interested if anyone else is hitting a similar issue - this sounds like a pretty serious bug, so we'd like to get it fixed as soon as possible before pushing 12.3 out...
I don't know specifics about how much memory Data Compare needs (it probably varies significantly based on the type of data in the rows as well as the number of rows being compared) but that sounds like something that should work.
First thing to look into would be updating to the latest version of Data Compare - we've done a bunch of bugfixing since 12.0.28, and I know in particular we've improved memory usage in the deployment wizard, so if that's where you're having trouble then it will probably help a lot.
If that doesn't help (or if you're having memory problems in other parts of the UI such as doing the comparison or viewing results) then we could look into the problem in more detail / comments
I don't know specifics about how much memory Data Compare needs (it probably varies significantly based on the type of data in the rows as well as the number of rows being compared) but that sounds...
Sorry to hear you're having trouble. There's a couple of things to try here:
- It's worth upgrading to the latest version - we've fixed a lot of bugs (and added a fair few features) between 12.0.33 and 12.3.1 so there's a decent chance we might have fixed this already
- If that doesn't work, then clicking on the 'More details' link should give you an option to send in the exception as an error report / alternatively getting in touch with support to figure out the reproduction would be really helpful / comments
Sorry to hear you're having trouble. There's a couple of things to try here:
- It's worth upgrading to the latest version - we've fixed a lot of bugs (and added a fair few features) between 12.0.33...
It sounds like an interesting idea, but I don't think this is supported at the moment - scripts folders are intended to be a representation of the database schema that is easy to read / put into source control, but we don't support actually trying to run the SQL contained in a scripts folder, since that's what deployment scripts are for. (As a small but unlikely example, imagine two tables which have FK references to each other - there's no way to correctly order those files to create the tables, but in a deployment script we can pull the table definitions apart and create the FKs after both tables exist)
There might be something we could do around splitting up a deployment script into multiple files that you could feed into your custom tool, but thinking about it there's a lot of work we'd have to do there to make the feature work well in a majority of cases so it's probably not worth it for SQL Compare / comments
It sounds like an interesting idea, but I don't think this is supported at the moment - scripts folders are intended to be a representation of the database schema that is easy to read / put into so...
This sounds like a SQL Prompt bug, but this is the old SQL Compare 11 forum - you probably want to post this over here / comments
This sounds like a SQL Prompt bug, but this is the old SQL Compare 11 forum - you probably want to post this over here
Unfortunately not at the moment - CREATE OR ALTER is a 2016 SP1 feature that Compare doesn't recognise yet. It's on the backlog to get into Compare soon, though / comments
Unfortunately not at the moment - CREATE OR ALTER is a 2016 SP1 feature that Compare doesn't recognise yet. It's on the backlog to get into Compare soon, though
Hi there - the Tools > Generate comparison results report menu option might be what you're looking for. You can generate an XML report that should be easy to search through programmatically or a HTML report that lists all the differences in a more human-readable format / comments
Hi there - the Tools > Generate comparison results report menu option might be what you're looking for. You can generate an XML report that should be easy to search through programmatically or a HT...
Yeah, we currently have a lot of behaviour tied up in that one checkbox and we know users have problems with it bringing in unexpected dependencies. We have some ideas for improving that part of the deployment UI (eg letting you select individual dependencies and telling you exactly why SQL Compare has decided to mark something as a dependency) but it's going to require a lot of backend work and we don't have any definite plans yet. In the meantime hopefully we'll be able to fix any specific bugs that you might encounter, though / comments
Yeah, we currently have a lot of behaviour tied up in that one checkbox and we know users have problems with it bringing in unexpected dependencies. We have some ideas for improving that part of th...