Bug #1542
SQL Server support broken
0%
Description
Support for the MS SQL Server database was maintained in versions prior to 1.3
of metacat. Now the xmltables-sqlserver.sql and the associated
upgrade*-sqlserver.sql are either not up to date or are missing entirely. Need
to port the database changes to SQL Server and test all functions, including
upgrades from 1.3 to 1.4 before releasing 1.4.
History
#1 Updated by Saurabh Garg about 17 years ago
Moving the target to version 1.5
#2 Updated by Saurabh Garg about 15 years ago
Here are the files which need to be updated:
1. src/xmltables-sqlserver.sql
2. src/upgrade-db-to-1.2.sql
3. src/upgrade-db-to-1.3.sql
4. src/upgrade-db-to-1.4.sql
5. src/upgrade-db-to-1.5.sql
6. src/upgrade-db-to-1.6.sql
7. src/edu/ucsb/nceas/dbadapter/SqlserverAdapter.java (getLeftJoinQuery() needs to be tested)
As we dont have any metacat servers in ms sql right now, I think upgrade scripts (2-6 above) are not important to fix this bug
#3 Updated by Redmine Admin over 8 years ago
Original Bugzilla ID was 1542