June 10, 2016 at 8:24 am
Hi
I am trying to update a much out of date UAT database from the current production.
There are however lots of collation issues.
the database collation is the same, the tables have compared and copied over no problem, those seemed happy with the collation.
is there anything I can do to ignore collation issues make everything use the same maybe?
thanks in advance
June 10, 2016 at 8:29 am
erics44 (6/10/2016)
HiI am trying to update a much out of date UAT database from the current production.
There are however lots of collation issues.
the database collation is the same, the tables have compared and copied over no problem, those seemed happy with the collation.
is there anything I can do to ignore collation issues make everything use the same maybe?
thanks in advance
Well, not sure since you have provided very vague information on what the problem may be, and we can't see what you see.
June 10, 2016 at 8:35 am
I have 2 servers PROD and UAT
all dev has been done on Prod recently, ive just started here and I want to do my dev on UAT (no dev environment)
first I need to update UAT with the same structure as Prod
so I am using Visual Studio Database compare to update the UAT database
however I am getting a lot of collation errors which is stopping me updating using the script provided
The server collations on UAT and PROD are the same
The database collations on both servers are the same
The server and database collations are however different but it is consistent in both Prod and UAT
I could go through the code on UAT and manually add the collation changes, I don't want to do this because then the Prod and UAT code would be different
do you have any idea why these errors are occurring?
June 10, 2016 at 8:37 am
erics44 (6/10/2016)
I have 2 servers PROD and UATall dev has been done on Prod recently, ive just started here and I want to do my dev on UAT (no dev environment)
first I need to update UAT with the same structure as Prod
so I am using Visual Studio Database compare to update the UAT database
however I am getting a lot of collation errors which is stopping me updating using the script provided
The server collations on UAT and PROD are the same
The database collations on both servers are the same
The server and database collations are however different but it is consistent in both Prod and UAT
I could go through the code on UAT and manually add the collation changes, I don't want to do this because then the Prod and UAT code would be different
do you have any idea why these errors are occurring?
What errors? I can't see the errors you are getting so no one here has any context from which to work.
June 10, 2016 at 8:41 am
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the UNION operation.
June 10, 2016 at 8:42 am
but general cannot resolve collation conflict errors
June 10, 2016 at 8:55 am
so I have procs on prod, id like to move to UAT
and I cant because of these Collation errors
yet the collation set up on both servers seems to be the same
June 10, 2016 at 8:59 am
I apologise for my incoherent posts
the problem is solved
I restarted visual studio and it wanted to resolve the collation errors its self this time before it updated the objects 🙂
June 10, 2016 at 9:01 am
You should start looking at the collation of character columns within the database looking for conflicts. From the one error message you posted it looks like there is a difference in collation between columns within tables, not at the database or server level.
June 10, 2016 at 9:11 am
Lynn Pettis (6/10/2016)
You should start looking at the collation of character columns within the database looking for conflicts. From the one error message you posted it looks like there is a difference in collation between columns within tables, not at the database or server level.
it did look like that, the compare had already altered all of these collation differences though when it had updated the tables
perhaps by closing and reopening management studio and/or visual studio this was refreshed somehow
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply