Activity overview
Latest activity by bluebird84
Brian Donahue wrote:
Sorry, just realized this is v7 and I am using v10. Is it possible for you to upgrade?
I downloaded the trial version of v10 and I have exactly the same issue as in V7 when using the same project file. I then created a new project and didn't have the issue. I compared the Options and the Include Identity Column option wasn't checked. Once that was checked in v7 and v10 it mapped correctly.
thanks / comments
Brian Donahue wrote:
Sorry, just realized this is v7 and I am using v10. Is it possible for you to upgrade?
I downloaded the trial version of v10 and I have exactly the same issue as in V7 whe...
Brian Donahue wrote:
In order to select the ID column as the comparison key, you must first select "custom", then ID appears in the list of candidates. You are probably better off with the default, though, since the index is already built on the ID column and indexes are going to have better performance.
Hope this helps.
Thanks for your reply. I've tried that and even after clicking Custom the ID column does not show up [image] / comments
Brian Donahue wrote:
In order to select the ID column as the comparison key, you must first select "custom", then ID appears in the list of candidates. You are probably better off with the defau...
SQL Data Compare 7 - Comparison Key missing
Hi,
I have the following table in 2 databases. When I try to setup a data compare between them, I'm not able to set the ID column as the Comparison Key. The ID column is not even in the list (See s...
I think I may have figured out a fix to my original problem. My idea was to change the rowguid default value in Dev to newsequentialID so it matched the replicated database but I think I needed to drop the original and create a new one instead.
I wasn't getting the order of the constraints or ALTER table statements correct which was causing the column creation to fail, but I think I've got the order correct now.
drop the newID() rowguid
ALTER TABLE dbo.[table1] ADD rowguid uniqueidentifier
ALTER TABLE [dbo].[table1] ADD CONSTRAINT [DF_table1_rowguid] DEFAULT (newsequentialid()) FOR [rowguid]
ALTER TABLE dbo.[table1] ALTER COLUMN rowguid uniqueidentifier NOT NULL
ALTER TABLE dbo.[table1] ALTER COLUMN rowguid ADD ROWGUIDCOL / comments
I think I may have figured out a fix to my original problem. My idea was to change the rowguid default value in Dev to newsequentialID so it matched the replicated database but I think I needed to ...
Ignore ROWGUID/ROWGUIDCOL columns
Hi,
I'm comparing our non-replicated Development database with our replicated UAT Database - using the compare I'd like to update the schema of the Replicated Database (new columns, new tables, new...
Evan Moss wrote:
Hello,
Thanks for your post.
There shouldn't be any reason Azure takes longer to compare besides possibly network latency.
One thing worth trying is to uncheck "Decrypt encrypted objects on 2005 and 2008 databases" in the options tab of the project screen in SQL Compare.
Please let me know if that helps or if you have any further questions.
Regards,
Evan
Thank you Evan, unchecking the "Decrypt encrypted objects on 2005 and 2008 databases" option took the comparison time down to under 5 minutes.
many thanks for your help / comments
Evan Moss wrote:
Hello,
Thanks for your post.
There shouldn't be any reason Azure takes longer to compare besides possibly network latency.
One thing worth trying is to uncheck "Decrypt encrypte...
Comparing 2008 R2 with Azure - Speed
Hi,
apologies if there is already another question regarding this, I've had a look but nothing obvious popped up in any searches of the forum. Also, if there's any additional information you requir...