Activity overview
Latest activity by mtran
So you mean I will have to sync the indexes if I also want the primary keys to move?
This has never happened before though. Previous versions did not remove primary keys.
I believe there is a max of 200 indexes that can by synced. We have run into this previously where it will error if there are more than 200 indexes. I think that was the reason why we ignored indexes during syncing. / comments
So you mean I will have to sync the indexes if I also want the primary keys to move?
This has never happened before though. Previous versions did not remove primary keys.
I believe there is a max ...
There is an ignore Indexes option.
I do not see one for keys. There is Foreign keys but no primary keys. / comments
There is an ignore Indexes option.
I do not see one for keys. There is Foreign keys but no primary keys.
Thanks, I will take a look at the code again.
How come when I use the UI, it does not show any differences in the table structure but the primary keys are not set in the destination database? / comments
Thanks, I will take a look at the code again.
How come when I use the UI, it does not show any differences in the table structure but the primary keys are not set in the destination database?
We are actually using the SDK, not the UI version. But when we compare using the UI, it does not show any differences even tho the primary keys are not there. / comments
We are actually using the SDK, not the UI version. But when we compare using the UI, it does not show any differences even tho the primary keys are not there.
Table primary keys are dropped
When I ignore Indexes, the primary keys are dropped after syncing the table schema.
I have a table with 5 primary keys. It is initially there before the sync, but they are gone after syncing.
Plea...
I continue to receive this error for saved projects.
Maybe some useful information for debugging:
The databases are on SQL Server 2008.
I am running Windows 7.
I have gotten all updates, currently running version 8.1.0.4.
If I change the database for comparison, I get the error. / comments
I continue to receive this error for saved projects.
Maybe some useful information for debugging:
The databases are on SQL Server 2008.
I am running Windows 7.
I have gotten all updates, currently ...
FieldMapping not valid for MatchingMappings
I have been receiving this error numerous times when using SQL Data Compare.
It successfully registers the databases but I get a Mapping error and can not move forward.
I don't have any special opt...
I think I found the solution. I am trying to pass the TableDifference from a method I created. From there I am trying to print the differences. I think when I dispose of the ComparisonSession before I return the TableDifference, it is deleting the temporary files. / comments
I think I found the solution. I am trying to pass the TableDifference from a method I created. From there I am trying to print the differences. I think when I dispose of the ComparisonSession be...
Backup before Synchronizing
Is there a command for backing up the database before synchronizing? Is the Database.SaveToDisk method the same as right clicking the database and creating a backup file?
Thanks
This is where it is trying to find the file:
'C:\Documents and Settings\mtran\Local Settings\Temp\RGDC-681d07b3-5c86-4bfd-976b-a3173e692ee0.idx'
Thought it would help. / comments
This is where it is trying to find the file:
'C:\Documents and Settings\mtran\Local Settings\Temp\RGDC-681d07b3-5c86-4bfd-976b-a3173e692ee0.idx'
Thought it would help.