Comments
Sort by recent activity
Sorry I was referring to the API. We need to move certain tables from one database to another and we already know which tables need to be moved. / comments
Sorry I was referring to the API. We need to move certain tables from one database to another and we already know which tables need to be moved.
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.
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...
I do not have anything running that cleans up temporary files. I am running as a local admin with local profile. Running Windows XP Prof, SP2. / comments
I do not have anything running that cleans up temporary files. I am running as a local admin with local profile. Running Windows XP Prof, SP2.
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.
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.
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?
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 ...