I have a client that was one of the early adopters of Microsoft Dynamics GP. When it was installed on an older version of SQL Binary collation was recomended and so their collation is still binary. Is there any way to use Management Reporter with binary databases? I know the Management Reporter database has to be DOCI.
*This post is locked for comments
I was suggesting moving everything to a DOCI collation and testing it. It is likely a complicated test to be certain that there would be no conflict in changing from the Binary sort order. I am not assuming there will not be a conflict, but if the client has remained current on GP and 3rd party versions, there should not be.
I assume you are talking about the Management Reporter database and not the 29 company databases that this client has that are in binary collation, is that correct? If I put the Management Reporter database on a separate instance, how do I connect to the 29 binary company databases? So I need a separate instance of SQL 2008 to house the management reporter database. I don't believe I can just do a restore on the companies because we could end up with many conflicts in the data since binary recognizes a difference between A and a, but DOCI does not.
In order to change the collation for SQL you will have to backup, install the SQL version needed with DOCI collation, and restore your databases to this instance. You may upgrade this way as well. Main caveat is that you will be moving from one SQL instance to another. In order to maintain your Logins and Database Users you should capture them and script their recreation with proper permissions. There is a white paper on this. support.microsoft.com/.../918992
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (