Bug #1542: SQL Server support broken - Metacat - Ecoinformatics Redmine

Actions

Copy link

Bug #1542

open

SQL Server support broken

Added by Matt Jones over 20 years ago. Updated about 18 years ago.

Status:

New

Priority:

Immediate

Assignee:

Saurabh Garg

Category:

metacat

Target version:

2.x.y

Start date:

04/30/2004

Due date:

% Done:

Estimated time:

Bugzilla-Id:

1542

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.

Actions

Copy link

Updated by Saurabh Garg about 20 years ago

Moving the target to version 1.5

Actions

Copy link

Updated by Saurabh Garg about 18 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

Actions

Copy link