Comments
Sort by recent activity
If you have differences in encryption and you are using the SQL Compare "ADD WITH ENCRYPTION" option then you should have the object that is really encrypted on the RIGHT hand side to ensure that they are equal.
However, what you are saying suggests that it is something more than this cauisng your problem. I will take a closer look into this and get back to you. May I just double check that you are using v5.2.0.32?
In answer to your last question. We would always say that you should test any change on a staging environment before running them on your production database to ensure you don't cause any problems with the database or dependent applications.
Also I think that best practices would suggest that any changes to a database's schema should be carried out when a database is not being used to avoid any contention issues.
Regards,
Jonathan / comments
If you have differences in encryption and you are using the SQL Compare "ADD WITH ENCRYPTION" option then you should have the object that is really encrypted on the RIGHT hand side to ensure that t...
Hi there
1) I take that you are using SQL 2000? Also can I check that you are not using the ADD WITH ENCRYPTION option?
2) The following should give you the average length of object name
SELECT len(name) from sysobjects COMPUTE avg(len(name))
Regards,
Jonathan / comments
Hi there
1) I take that you are using SQL 2000? Also can I check that you are not using the ADD WITH ENCRYPTION option?
2) The following should give you the average length of object name
SELECT len...
Hi there,
1) Is it possible for you to post the db1 and db2 scripts for an object that demostrates this behaviour, so that we can take closer look at your problem?
2) Unfortunately the grid columns have a fixed width, you will get a tooltip if the object name exceeds the column width, but I can see this is a problem if you have lots of similarly named objects. May I ask what your average object name length is? We may look into addressing this is in future releases.
Regards,
Jonathan / comments
Hi there,
1) Is it possible for you to post the db1 and db2 scripts for an object that demostrates this behaviour, so that we can take closer look at your problem?
2) Unfortunately the grid columns...
Dave,
Sorry this is not possible at the moment in the UI, but we are considering adding this feature to future versions of SQL Compare.
Regards,
Jonathan / comments
Dave,
Sorry this is not possible at the moment in the UI, but we are considering adding this feature to future versions of SQL Compare.
Regards,
Jonathan
Jason,
Thanks for point out this issue we will get this fixed for the next release of SQL Bundle.
Regards,
Jonathan / comments
Jason,
Thanks for point out this issue we will get this fixed for the next release of SQL Bundle.
Regards,
Jonathan
webyeti,
Glad you like the product, I have some good news and some not so good news:
Firstly good news, if you email support@red-gate.com and reference this post they should be able to sort you out with an fix that ignores the order of columns in the INCLUDE clause.
Now the not so good news. Those brackets, although fairly minor I know this issue irrates customers. We are at the moment undertaking requirements gathering for the next version of SQL Compare and whilst I am really hoping that the SQL Differences gets an overhall I cannot promise that everything that goes into the list will be done.
Hope this helps,
Regards,
Jonathan / comments
webyeti,
Glad you like the product, I have some good news and some not so good news:
Firstly good news, if you email support@red-gate.com and reference this post they should be able to sort you out...
Hi there,
Thanks for your suggestion, we may consider this for future versions. However, if you wanted to do this right now it should be possible to do this by either:
a) Using a command line batch file and a scheduled task.
b) Using the SQL Toolkit's to write a .NET application to compare the entire instance.
Regards,
Jonathan / comments
Hi there,
Thanks for your suggestion, we may consider this for future versions. However, if you wanted to do this right now it should be possible to do this by either:
a) Using a command line batc...
Hi mcintyre321,
I think I have been able to reproduce your issue here, it appears there something strange happening with the ADD WITH ENCRYPTION option.
This might sound a bit strange but can I ask you what the result of comparing the databases the other way around? So that CGixLatest is on the left and CGiX6517 is on the right?
Regards,
Jonathan / comments
Hi mcintyre321,
I think I have been able to reproduce your issue here, it appears there something strange happening with the ADD WITH ENCRYPTION option.
This might sound a bit strange but can I ask...
Hi Lumbago,
We felt that we really should use square brackets as a safety measure for those who have used reserved words, spaces, etc in object names. We may implement your suggestion for an option to turn them off in future versions, but I am afraid that this will not make the v1.0 release.
Sorry and hope you like the rest of the product.
Regards,
Jonathan / comments
Hi Lumbago,
We felt that we really should use square brackets as a safety measure for those who have used reserved words, spaces, etc in object names. We may implement your suggestion for an optio...
Hi there dineshasanka,
Can you give us a bit more information about this glitch? A screen capture would be great if it is possible, if not could you provide a bit more of a description.
Also is it possible for some information about your client pc's setup?
Many thanks,
Jonathan / comments
Hi there dineshasanka,
Can you give us a bit more information about this glitch? A screen capture would be great if it is possible, if not could you provide a bit more of a description.
Also is it ...