In October and November of 2024, the SQL Server 2016 data mart shared hosting systems will be refreshed and migrated to SQL 2019 shared hosting systems. This page serves to answer frequently asked questions for these database system refreshes.
What systems will be refreshed and when?
What systems will be refreshed and when?
The test system IOWASQLDMTEST3 will be refreshed on Monday, October 28, 2024, at 6 pm - 8 pm Central Time.
The production system IOWASQLDMHOST3 will be refreshed on Sunday, November 17, 2024, at 10 am - noon Central Time.
Where will the systems be moved to?
Where will the systems be moved to?
The test system IOWASQLDMTEST3 will be migrated to IOWASQLDMTEST5.
The production system IOWASQLDMHOST3 will be migrated to IOWASQLDMPROD5.
Will I need to update my connection strings or SQL Server drivers?
Will I need to update my connection strings or SQL Server drivers?
Connection strings to the new systems may require the fully qualified domain name of the database server (e.g. IOWASQLDMHOST3.iowa.uiowa.edu). You will not immediately be required to update the connection string to use the alias IOWASQLDMPROD5 or IOWASQLDMTEST5.
Connection strings that use an IP address will need to be updated to reflect the IP address of the new systems.
Drivers must support encryption in transit. For some drivers, the connection string may require explicit addition of the flags "Encrypt=True" or "TrustServerCertificate=True"
How will network connectivity to my database change after the migration?
How will network connectivity to my database change after the migration?
The current SQL Server 2016 systems are open to UIOWA-NETS (all campus networks, including data centers, campus buildings, campus wireless, and VPN).
The new SQL Server 2019 systems will be open to ITS data centers and, on request, static IP addresses on wired campus building machines. They will NOT be open to campus wireless or VPN.
How do I request network access to my database?
How do I request network access to my database?
To request network access to the new SQL Server 2019 systems on a wired computer or building subnet outside of the data centers, contact the SQL DBA team at ITS-SQL-Help@uiowa.edu
What do I do if my databases need to be accessed via campus wireless or VPN?
What do I do if my databases need to be accessed via campus wireless or VPN?
Databases that require connectivity to campus wireless or VPN cannot reside on the new SQL Server 2019 shared hosting systems. They will need to be migrated to the following option no later than Friday, November 15, 2024.
- A dedicated SQL Server system
For further assistance with this topic, contact the SQL DBA team at ITS-SQL-Help@uiowa.edu to set up a consultation.
How can I test network connectivity to the new SQL Server instances?
How can I test network connectivity to the new SQL Server instances?
In PowerShell on the system that needs to connect to SQL Server, use the following command:
Test-NetConnection -ComputerName IOWASQLDMPROD5.iowa.uiowa.edu -Port 1433
A successful connection will return a response like this:
A failed connection will return a response like this:
Is my SQL Server 2016 database compatible with SQL Server 2019?
Is my SQL Server 2016 database compatible with SQL Server 2019?
The SQL DBA team ran Microsoft’s Data Migration Assistant against all databases and no errors were reported by the tool.
Can I move my SQL Server 2016 database to SQL Server 2019 systems prior to the scheduled migration date?
Can I move my SQL Server 2016 database to SQL Server 2019 systems prior to the scheduled migration date?
Yes. If you would like to move your database prior to the scheduled migration date, please contact the SQL Server DBA team at ITS-SQL-Help@uiowa.edu
Last updated
Article number
7806