JURNAL TEKNOLOGI INFORMASI: Teori, Konsep, dan Implementasi VOL. 1 NO. 1 TAHUN 2010
Articles

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

PDF (Indonesian)
  • Banni Satria Andoko
Banni Satria Andoko
STMIK PPKIA Pradnya Paramita Malang

Published 13-03-2010

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
PDF (Indonesian)

References

  1. Andrew J. Brust, Stephen Forte. 2006. Programming Microsoft® SQL Server™ 2005. USA : Microsoft Press
  2. Andrew Watt. 2005. Microsoft.SQL.Server.2005.For.Dummies.(2006).BBL. Hoboken: Wiley Publishing, Inc
  3. Conolly, Thomas & Begg, Carolyn. (2002). Databases Systems : A Practical Approach to Design, implementation and management. Third Edition. Addision Wesley, England.
  4. Gordon,Steven. R. (1996). Information System : A Management Approach. Hartcourt Brace Company, Orlando.
  5. Itzik Ben-Gan, Dejan Sarka and Roger Wolter, 2006. Inside Microsoft SQL Server 2005. USA : Microsoft Press A Division of Microsoft Corporation
  6. Jogiyanto HM. 1993. Analisis Dan Desain Sistem Informasi : Pendekatan Terstruktur Teori dan Praktek Aplikasi Bisnis. Yogyakarta : Andi Offset
  7. MCLeod, Jr. Raymond. (2001). Sistem Informasi Manajemen, Edisi ke-7, Jilid-1. Terjemahan Hendra Teguh,SE, AK. PT.Prenhallindo, Jakarta.
  8. Michael Otey, 2005. Microsoft SQL Server 2005 New Features. California : McGraw-Hill/Osborne
  9. http://msdn.microsoft.com/
  10. Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein,et al, 2007. Ms SQL Server 2005 Unleashed. USA : Sams Publishing
  11. Rick F. van der Lans. 2006 Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition: Addison Wesley Professional
  12. http://www.sqlis.com/
  13. http://sqlug.be/
  14. Zhao Hui Tang And Jamie MacLennan. 2005. Data Mining with SQL Server2005. Canada : Wiley Publishing Inc