Red Gate forums :: View topic - New 2008 data types in SQL Compare
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

New 2008 data types in SQL Compare

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
CGLuttrell



Joined: 10 Sep 2009
Posts: 18
Location: Knoxville, TN

PostPosted: Wed Mar 07, 2012 12:41 am    Post subject: New 2008 data types in SQL Compare Reply with quote

When we use the newer data types and we are comparing to svn or a scripts folder, Compare always shows it as a difference and prefixes the type with [sys] like this:
http://www.evernote.com/shard/s69/sh/6ee8572a-251d-4598-b975-7c904fc2d791/060ea8614b6d4908107370c97c89bc8c
Back to top
View user's profile Send private message AIM Address MSN Messenger
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Fri Mar 09, 2012 10:42 am    Post subject: Reply with quote

Thanks for your post.

I believe this can happen if your script folder in source control is set to SQL 2005.

The attribute for this is set in the RedGateDatabaseInfo.xml file in the root of the repository.

The database being treated as SQL 2005 can happen if the file is missing, or if the database was originally created from a SQL 2005 database.

You should be able to change the behaviour if you manually change the file to SQL 2008. If it's missing completely, you can create a new link to a blank repository and then take the XML file from that.

I hope this helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
CGLuttrell



Joined: 10 Sep 2009
Posts: 18
Location: Knoxville, TN

PostPosted: Fri Mar 09, 2012 5:53 pm    Post subject: Worked! Reply with quote

Thanks, that worked great.
You were correct, I had created the original repository against the database when it was still on 2005 and did not know about this attribute.
For others clarification what I found was the line:
Code:
<DatabaseVersion>9</DatabaseVersion>

and I changed it to
Code:
<DatabaseVersion>10</DatabaseVersion>

Besides the new data types that I was noticing, after the change and a new compare I also found that it was quietly ignoring filtered indexes we had added in 2008. I am glad to have this resolved before I had to rebuild from svn and lost those features.
Thanks for your help.
Chris Luttrell
Back to top
View user's profile Send private message AIM Address MSN Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group