Skoči na glavni sadržaj

Stručni rad

IMPACTS OF MS SQL SERVER SYSTEM DEVELOPMENT ON STABILITY OF BUSINESS APPLICATIONS AND DATABASES

Stjepan Vidačić orcid id orcid.org/0000-0001-5043-1288 ; Faculty of Organization and Informatics, University of Zagreb, Varaždin, Croatia
Mario Špicar ; Faculty of Organization and Informatics, University of Zagreb, Varaždin, Croatia


Puni tekst: hrvatski pdf 685 Kb

str. 175-186

preuzimanja: 286

citiraj


Sažetak

The rapid development of MS SQL server system and the manufacture of its new versions over the past twenty years has had a significant impact on the stability of business SQL databases and pertaining applications, and also on the business information systems (IS) in general. The manufacture of MS SQL servers 6.0, 6.5, 7.0, 2000, 2005, 2008, 2012, 2014, 2016, 2017 points to the fact that the time elapsed between two versions of that system has shortened from several years two to one year. This raises a number of questions, such as: how does this accelerated development affect the active business SQL databases?; is the continual procurement and installation of new versions of MS SQL servers something that users absolutely need?; does the manufacturer guarantee a 100% compatibility and option of routine migration of the existing SQL bases to the new MS SQL server system or there are certain problems that the user may expect?; how will, in the long run, that affect the stability of users' IS and the safety of business databases?; what is the real cost for the users of continual production of new versions of MS SQL servers?; what are potential risks for the users thereof?; etc. In the sense of the above, the primary goal of this paper is to provide a historical overview of the versions of MS SQL servers, including major novelties that the new versions bring about, particularly in terms of compatibility with the SQL bases of the previous versions of that system. Secondly, the paper aims to propose optimal and rational dynamic of substituting one version of MS SQL server system with another, which the users should do if they want to keep up with the development of technology, but with minimum risks and expenses. The third goal is to propose the methodology of migration of the active SQL database from the currently used version to a new version of the MS SQL server so as to ensure stability of business database and applications, and the business information systems in general.

Ključne riječi

MS SQL server; SQL base; migration of SQL base; information system; business applications

Hrčak ID:

234542

URI

https://hrcak.srce.hr/234542

Datum izdavanja:

1.3.2019.

Podaci na drugim jezicima: hrvatski

Posjeta: 856 *