Project

General

Profile

Actions

Bug #1542

open

SQL Server support broken

Added by Matt Jones almost 19 years ago. Updated over 16 years ago.

Status:
New
Priority:
Immediate
Assignee:
Category:
metacat
Target version:
Start date:
04/30/2004
Due date:
% Done:

0%

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 #1

Updated by Saurabh Garg over 18 years ago

Moving the target to version 1.5

Actions #2

Updated by Saurabh Garg over 16 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 #3

Updated by Redmine Admin almost 10 years ago

Original Bugzilla ID was 1542

Actions

Also available in: Atom PDF