Project

General

Profile

Bug #1542

SQL Server support broken

Added by Matt Jones about 15 years ago. Updated over 12 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.

History

#1 Updated by Saurabh Garg over 14 years ago

Moving the target to version 1.5

#2 Updated by Saurabh Garg over 12 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 about 6 years ago

Original Bugzilla ID was 1542

Also available in: Atom PDF