MIGRASI DATABASE DENGAN MENGGUNAKAN SSIS (SQL SERVER INTEGRATION SERVICE) DI PT XYZ INDONESIA

Banni Satria Andoko

doi:10.36382/jti-tki.v1i1.141

Banni Satria Andoko STMIK PPKIA Pradnya Paramita Malang

DOI: https://doi.org/10.36382/jti-tki.v1i1.141

Abstract

PT. INDONESIA XYZ is the largest Direct Selling company in Indonesia that have strong growth in comparison with other Direct Selling companies in Indonesia. With the rapid development of PT XYZ INDONESIA, then decided to update its sales application that can not follow the process of starting a thriving business. In addition the needs of data storage capacity becomes very large. To be able to meet that need, so the new system required a more reliable and faster in performance. By looking at the problem, we needed a system / application that can move and manipulate the old data so it can be used by the new system. Database migration process is designed using one of the facilities provided by MS SQL 2005, the facility is named SSIS (SQL Server Integration Service).

Keyword : Data Migration, SSIS, ETL, MsSQL 2005, RDBS, SQL Query

References

Andrew J. Brust, Stephen Forte. 2006. Programming Microsoft® SQL Server™ 2005. USA : Microsoft Press

Andrew Watt. 2005. Microsoft.SQL.Server.2005.For.Dummies.(2006).BBL. Hoboken: Wiley Publishing, Inc

Conolly, Thomas & Begg, Carolyn. (2002). Databases Systems : A Practical Approach to Design, implementation and management. Third Edition. Addision Wesley, England.

Gordon,Steven. R. (1996). Information System : A Management Approach. Hartcourt Brace Company, Orlando.

Itzik Ben-Gan, Dejan Sarka and Roger Wolter, 2006. Inside Microsoft SQL Server 2005. USA : Microsoft Press A Division of Microsoft Corporation

Jogiyanto HM. 1993. Analisis Dan Desain Sistem Informasi : Pendekatan Terstruktur Teori dan Praktek Aplikasi Bisnis. Yogyakarta : Andi Offset

MCLeod, Jr. Raymond. (2001). Sistem Informasi Manajemen, Edisi ke-7, Jilid-1. Terjemahan Hendra Teguh,SE, AK. PT.Prenhallindo, Jakarta.

Michael Otey, 2005. Microsoft SQL Server 2005 New Features. California : McGraw-Hill/Osborne

http://msdn.microsoft.com/

Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein,et al, 2007. Ms SQL Server 2005 Unleashed. USA : Sams Publishing

Rick F. van der Lans. 2006 Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition: Addison Wesley Professional

http://www.sqlis.com/

http://sqlug.be/

Zhao Hui Tang And Jamie MacLennan. 2005. Data Mining with SQL Server2005. Canada : Wiley Publishing Inc