Red Gate forums :: View topic - Unknown type - sys.date
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

Unknown type - sys.date

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



Joined: 23 Jul 2013
Posts: 1

PostPosted: Tue Jul 23, 2013 4:10 am    Post subject: Unknown type - sys.date Reply with quote

Hi All,

I'm using SQL Source Control 3 and when i tried linking my database to a SQL 2005 server, i am getting "Unknown type - sys.date" error.

I am not able to perform "Get latest" due to this error as well.

Any help is greatly appreciated.
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Thu Jul 25, 2013 3:16 pm    Post subject: Reply with quote

Can you clarify exactly what it is you're doing? You said "linking my database to a SQL 2005 server" - what do you mean by that?

Usually this kind of error suggests a SQL Server version mismatch - if you're linking to a repository of scripts generated by SQL Source Control on a different version of SQL Server, SQL Source Control may not be able to apply them to your database because the object creation scripts may use features not present in SQL 2005.
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
Totu



Joined: 07 Apr 2014
Posts: 10

PostPosted: Mon Jun 23, 2014 11:29 am    Post subject: Reply with quote

Hi,

Last Friday I bumped into the same error message in one for our CD pipelines, here is my fix:

As Andy described, the error is thrown because the product thinks you have an old version of SQL Server as a source or target. Why does it think like that when my SQL Server is 2008 R2?

When I was looking at the logs I found this line that gave me a hint:
Code:
Warning: The SQL Server version specified for the scripts folder


I went into the RedGateDatabaseInfo.xml and looked for something about the version and removed the DatabaseVersion tag. After running the pipeline again, it successfully finished.

I hope this helps.

Cheers,
Balint
_________________
Bálint Bartha, Skyscanner
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Thu Jun 26, 2014 3:58 pm    Post subject: Reply with quote

That's correct- the xml file will normally be populated with information about the server and database version, and if these are incorrect it'll change the behaviour.
I believe it used to default to assuming 2005 which is why this error used to come up a lot more regularly- I think we may have changed the default to a more recent version which is why removing the info perhaps helped.
Back to top
View user's profile Send private message
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