Hey. Here are the mssqlserver backend files my org is using for their old roundup issue tracker install. I'm not sure if back_mssqlserver.pyc or _old.pyc would be of interest to you, but I've included them just in case.

I have no expectation for anyone to convert this backend for python3 and newer versions of issue tracker for me. But if you'd like, you can use this as reference to implement an mssqlserver backend alternative for future versions. We don't own this and I don't believe it was anyone in my org wrote who it. Maybe modified.

Thanks for all your help!

Hi Randy, not sure if you are still around. I don't see you on IRC.
I had somebody ask about this ticket.

In the irc chat, I mentioned that the dbi module seems to be unused and I though
pyodbc might be able to be used to replace the odbc module imported by back_mssqlserver.

Do you know if my guesses are correct?

Also have you made any progress in moving your roundup instance?

Have a good day.

-- rouilj

Hey John,

Good to hear from you. I just looked through the last version of 
back_mssqlserver I was messing with for pyodbc, and did not see any use of 
it to confirm your theory. Unfortunately I am not familiar enough with 
python development to offer better insight.

Nah, I wasn't able to migrate or upgrade our roundup instance. Last thing 
I tried was to drag n drop our Python and roundup folders off the old 2008 
server and into a newer 2025 server. I think it served out a working main 
page with tickets, but links and login functionality were broken. I was 
spending too much time on it and ultimately had to shift gears to work on 
other things. But it's still something one of us needs to address at some 
point. Just not now with other projects going on.

Hope you find the answer to your question. Thanks for checking in!

From:   "John Rouillard" <issues@roundup-tracker.org>
To:     patrick.murray@pha.phila.gov
Date:   04/13/2025 11:17 PM
Subject:        [issue2551394] mssqlserver backend files
Sent by:        issues@roundup-tracker.org

CAUTION: This Email is from an EXTERNAL source. Ensure you trust this 
sender before clicking on any links or attachments.

John Rouillard added the comment:

Hi Randy, not sure if you are still around. I don't see you on IRC.
I had somebody ask about this ticket.

In the irc chat, I mentioned that the dbi module seems to be unused and I 
though
pyodbc might be able to be used to replace the odbc module imported by 
back_mssqlserver.

Do you know if my guesses are correct?

Also have you made any progress in moving your roundup instance?

Have a good day.

-- rouilj

----------
nosy: +rouilj

_________________________________________________
Roundup tracker <issues@roundup-tracker.org>
<
https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.roundup-2Dtracker.org_issue2551394&d=DwIFaQ&c=pTMmftTp0eOqX5h_B2WLq0DUIZO-1izRe_CcgPLX088&r=Z2rb6s109oq7YRKGmXWSa7Fd4M21eAdFLJ58RP_-x6A&m=i1thdIX00K252HEBn_rehDaetPTCWWPyxUSHQOt_U03OzsVNHgERKMIyfvyrLR_C&s=Zh-vItG9BEUbUeKRtHwzh6MbioX2Znxdqh_Te_nd0g0&e= 
>
_________________________________________________