Stručni rad
IMPACTS OF MS SQL SERVER SYSTEM DEVELOPMENT ON STABILITY OF BUSINESS APPLICATIONS AND DATABASES
Stjepan Vidačić
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
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
Datum izdavanja:
1.3.2019.
Posjeta: 1.629 *