Red Gate forums :: View topic - HIGH: Unsupported datatypes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

HIGH: Unsupported datatypes

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ArrJay



Joined: 08 Nov 2012
Posts: 2

PostPosted: Thu Nov 08, 2012 4:46 pm    Post subject: HIGH: Unsupported datatypes Reply with quote

Hi all - I am currently in the process of setting up Source Control. Everything seemed to be going well until we decided to test the process with a live production update.

The staging database that we are committing changes from is an exact copy of the production database, i.e. the staging database was restored from the production database's backup...and no changes have occurred on the production database since the last backup.

We added a single bit field to our table, committed the change to Subversion and attempted to commit the change through Source Control.

We received the following error message -

High:Unsupported datatype
Severity: High
Object: SupplierVenue
Title: The type Date on object [dbo].[SupplierVenue].[DateCreated] is not supported in the target database version.

There was no change to this table, I have looked in sys.object to confirm the modified date and the last update was over two months ago.

Why would Source Control identify an unsupported datatype when I'm not committing a Date field change and there has been no changes to the SupplierVenue table.

Kind regards, Russell.
Back to top
View user's profile Send private message
ArrJay



Joined: 08 Nov 2012
Posts: 2

PostPosted: Fri Nov 09, 2012 12:06 pm    Post subject: Version conflict Reply with quote

Hi there - Through further investigation, I have identified that my staging server is running a different version of SQL to production.
Is there a known issue when committing updates from SQL2008 to SQL2008 R2?
What is puzzling me is the fact that Source Control only identified two date fields that are not support however there are loads of date fields within the database....

Any response would be helpful on this.....

Regards, Russell.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 921
Location: Red Gate Software

PostPosted: Mon Nov 12, 2012 12:13 pm    Post subject: Reply with quote

Hi, thank you for forum post and sorry that you have encountered a problem.

A support call has bee created for you, the call reference is F0066642.

Can you please please send an e-mail to support@red-gate.com and include the creation script for the 'SupplierVenue' table? Also please attach a copy of the SQL Source Control log file for when this problem occurred? By default you the log files are located in this folder?:
C:\Users\<user_name>\AppData\Local\red gate\Logs\SQL Source Control 3

Please include the above call reference number in the subject field of the e-mail.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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