May 13, 2019 at 11:45 am
Hello everyone ,
I need to migrate databases to RDS AWS what worries me is that RDS he proposes the collation SQL_Latin1_General_CP1_CI_AS most of my bases are collation French_CI_AS
Does having two different snacks create a problem for me?
will there be a method that allows me to test before performing a migration operation
thanks
May 13, 2019 at 4:27 pm
That's likely a default. Having your database as a different collation than the server instance is not a problem. You may have issues if you use temp tables, in which case you'll need to add a COLLATION clause to joins with temp tables to ensure the collation used is the one you want. Here's a short note on the issue: https://dba.stackexchange.com/questions/161012/database-collation-different-from-tempdb-collation
You can create your temp tables with the proper collation, but using the "collation phrase" in the create #table statement.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply