Link to home
Start Free TrialLog in
Avatar of nav2567
nav2567Flag for United States of America

asked on

Moving Dynamic GP database to another SQL 2012 server.


We are trying to move  our Dynamic GP 2013 12.00.1547 database to another SQL server 2012.  

I am trying to follow steps in this article

but I am not able to get the Capture_Logins.sql from the download link in the article.  

Does anyone know or have an idea?

Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi nav2567,

I've attached two versions of the Capture Logins script.

The original does not appear to work on newer versions of SQL--it gives me an error on SQL 2017. But I haven't tested it on SQL 2012, so you'll have to see if it works for you.

The second one is a very slightly modified version of the script that works for me on SQL 2017.

Two differences: Dates of 4/30/2014 vs 5/2/2014 are listed in the comments.  And the SQL version check is different.

KB878449_Capture_Logins - Original.sql

KB878449_Capture_Logins - Works on SQL 2017.sql

Let me know if those work for you.

Steve Endow
Microsoft MVP
Avatar of nav2567


Thanks, everyone!