Comments
Sort by recent activity
paschott wrote:
Where would we get more information about using the two together? It almost sounds as if we could restore a table directly from backup without needing to restore the entire DB. Is that correct or am I way off base? That feature would pay for the product very quickly. It's painful to need to restore a full backup when I only need a small number of tables.
Thanks.
-Peter Schott
Hi Peter,
you are right, you can use SQL Compare 7 Pro to restore a database table (or a selected database objects) only. SQL Compare Pro can load in the backup file (both SQL Server backups and Red Gate's SQL Backups). To read a backup you just need to select "Backup" in the SQL Compare project configuration dialog as the "Data Source Type". SQL Compare will be able to restore all the details of your schema directly from the backup. For the data in the table, you can then use SQL Data Compare Pro (Note, that the currently released Data Compare, i.e. not a beta, already has this functionality, and can handle database backups). Concerning more detailed information, we will post some case studies and walktroughs nearer to the final release. In the meantime, please feel free to ask us questions through this forum.
Regards,
Andras / comments
paschott wrote:
Where would we get more information about using the two together? It almost sounds as if we could restore a table directly from backup without needing to restore the entire DB. ...
jimboh wrote:
In the SQLCompare 7 Beta UI where I have added multiple backup files in the RHS list. On switching from one to another, the target source caption in the header area does not change to reflect the new source target but retains the title of the initial backup source target. However, the tooltip text does show the correct current comparison paths.
Thank you for reporting this issue. We will look into this for the final release.
Regards,
Andras / comments
jimboh wrote:
In the SQLCompare 7 Beta UI where I have added multiple backup files in the RHS list. On switching from one to another, the target source caption in the header area does not change...
Stefano Paparesta wrote:
You can release a free utility to create a database snapshot for synchronization with SqlCompare 7.
Many thanks
Stefano
Hi Stefano,
this is a very good idea. We will certainly consider including it in our tool.
Many thanks,
Andras / comments
Stefano Paparesta wrote:
You can release a free utility to create a database snapshot for synchronization with SqlCompare 7.
Many thanks
Stefano
Hi Stefano,
this is a very good idea. We will c...
We have just released SQL Compare 7.0. I would like to thank you for all your comments. With your help we have improved SQL Compare even more, and have included features that we did not think about before, like the option to include use statements at the beginning of scripts.
The beta for SQL Compare 7.0 is now official closed and the forum will be locked. Please use the forum for SQL Compare 7 on http://www.red-gate.com/messageboard/viewforum.php?f=81.
Kind regards,
Andras / comments
We have just released SQL Compare 7.0. I would like to thank you for all your comments. With your help we have improved SQL Compare even more, and have included features that we did not think about...
If your data is being changed between the start of the comparison and the synchronization, then reseeding the identity value does not make much sense, exactly because of the conflicts you are experiencing. You can control whether identity columns should be reseeded via project options.
Use Edit project-> Options -> Reseed identity columns
If your databases seem to follow the above usage pattern, then you can even save this option as "My Defaults" so that new projects will not have the "Reseed identity columns" set.
Kind regards,
Andras / comments
If your data is being changed between the start of the comparison and the synchronization, then reseeding the identity value does not make much sense, exactly because of the conflicts you are exper...
dpuza wrote:
I can't run SQL Compare 6.2 or SQL Data Compare 6.0 - brand new install. Attempting to start either program crashes it with a "TypeInitializationException". Please help!
Do you have any other tools that use DevExpress? They provide a library we use in our UI, and there is a problem with their library that is detailed with a possible solution on http://www.red-gate.com/support/kb/KB200708000126.htm
Regards,
Andras / comments
dpuza wrote:
I can't run SQL Compare 6.2 or SQL Data Compare 6.0 - brand new install. Attempting to start either program crashes it with a "TypeInitializationException". Please help!
Do you ...
Ben Mills wrote:
Didn't there used to be a mapping piece to SQL Compare where you could map fields? Maybe a few versions ago?
Ben
Hi Ben,
SQL Compare does not allow mapping columns. We have been looking into this feature, but it has not made it into the releases. Problems usually arise bacause of computed columns, constraints, forign keys, triggers, etc. and these cannot always be reliably refactored on demand either for comparison of for synchronization purposes.
However, SQL Data Compare supports column mapping, as the above problems are not present during data comparison.
Regards,
Andras / comments
Ben Mills wrote:
Didn't there used to be a mapping piece to SQL Compare where you could map fields? Maybe a few versions ago?
Ben
Hi Ben,
SQL Compare does not allow mapping columns. We have b...
slhale wrote:
It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following error when one of those existing views is accessed:
Msg 4502, Level 16, State 1, Line 1
View or function '<view>' has more column names specified than columns defined.
Many thanks for reporting this. I have raised this as a bug, and we will fix this in a future version.
Regards,
Andras / comments
slhale wrote:
It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following...
Yuri wrote:
In Synchronization wizard on tabs "Action Plan" and "Modifications" there is an option "Copy to Clipboard" (on right-mouse-click), but it does not seem to copy anything for Action Plan or Modifications.
Am I doing anything wrong?
I'd like to save list of modifications for my reference.
I'm using trial version 6.2.0.271.
Thanks
Yuri
Hi Yuri,
this is a regression that has slipped into 6.2. I have raised this issue and we will fix it soon. We will send you a private build that will work once this is fixed.
Regards,
Andras / comments
Yuri wrote:
In Synchronization wizard on tabs "Action Plan" and "Modifications" there is an option "Copy to Clipboard" (on right-mouse-click), but it does not seem to copy anything for Action Pl...
gsuttie wrote:
Hi Folks
What tool would I use to find out what execute permission UserA has on the database stored procs?
Is there a tool I can use to select a user and see what rights they have at every level?
Cheers
Gregor
Hi Gregor,
If you are looking for the effective permissions, i.e. that consider the role membership of a user, and the permissions assigned to both the roles and the users, then you could use Microsoft's Management Studio. In the Object Explorer find the user, select properties, Securables, Effective Permissions.
SQL Compare can show you the database level permissions for users, however object level permissions, following Microsoft's format of script creation, are shown with the database objects.
Regards,
Andras / comments
gsuttie wrote:
Hi Folks
What tool would I use to find out what execute permission UserA has on the database stored procs?
Is there a tool I can use to select a user and see what rights they have...