Penerapan Database Impor dan Ekspor Menggunakan SQL Server 2008
DOI:
https://doi.org/10.55123/mamen.v2i3.2043Keywords:
Diagrams, Export Import, Tutorial, Relations, SQL Server 2008Abstract
Import data is the process of retrieving data from another database, such as Microsoft Access to SQL Server 2008, can also be Microsoft Excel, you have imported data into SQL Server 2008. We can import from Microsoft Access if we wish, all tables and data or only some of them will be imported from Microsoft Excel. If we import from Microsoft Access, then yes the primary key is lost and the datatype is changed according to the existing data type in SQL Server 2008 and imported from Microsoft Excel. The data export process is the process of moving data from a database in SQL Server 2008, to another database, such as Microsoft Access, or it could also be Microsoft Excel. We can export data from SQL Server 2008 to Microsoft Access all tables and data or just some of them so if we do this export to Microsoft Excel. This article covers how to export and import data the program uses SQL Server 2008. The first step taken is a case study of the Microsoft Access Teaching Schedule database which is made of a link along with the information content. Next, how to import the database to SQL Server 2008, create primary keys and relations to form DBMS graphs with SQL Server 2008. Based on the database that was created, we export the chart to Microsoft Excel.
Downloads
References
Nugroho, Mengembangkan Aplikasi Basis Data Menggunakan C#+SQL Server. Yogyakarta: Andi, 2010.
Knight, E. Veerman, G. Dickinson, D. Hinson, and D. Herbold, Microsoft SQL Server 2008 Integration Services. Canada: Wiley Publishing, 2008.
Setiyadi and D. Abdullah, Mudah dan Cepat Belajar Database dengan SQL Server 2008. Lhokseumawe: Sefa Bumi Persada, 2020.
Setiyadi, Sistem Basis Data dan Structured Query Language (SQL). Bekasi: PT. Mitra Wacana Media.
Y. Anggraeni and R. Irviani, Pengantar Sistem Informasi. Yogyakarta: CV. Andi Offset, 2019.
H.Talib, Panduan Lengkap MS Access 2013. Jakarta: PT. Elex Media Komputindo, 2014.
I.Hermawan, Metodologi Penelitian Pendidikan, Kuantitatif, Kualitatif dan Mixed Methode. Kuningan: Hidayatul Quran Kuningan, 2019.
Indrajani, Database Design All in One (Theory, Practice and Case Study). Jakarta: PT Elex Media Komputindo, 2018.
M. R. Arief, Pemrograman Basis Data Menggunakan Transact-SQL dengan Microsoft SQL Server 2000. Yogyakarta: CV. Andi Offset, 2006.
R. Fiva, Pintar Menulis Karangan Ilmiah, Kunci Sukses Dalam Menulis Ilmiah. Yogyakarta: Andi, 2010.
Suryadharma and T. Budyastuti, Sistem Informasi Manajemen. Jawa Timur: Uwais Inspirasi Indonesia, 2019.
V. N. Anwar, “Implementasi Data Import Apache Solr Untuk Keperluan Indexing Data Buku,” vol. 9, pp. 50–59, 2019.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Yuda Mahendra Hasibuan, Muhammad Irwan Padli Nasution
This work is licensed under a Creative Commons Attribution 4.0 International License.
Hak cipta pada setiap artikel adalah milik penulis.
Penulis mengakui bahwa MAMEN (Jurnal Manajemen) sebagai publisher yang mempublikasikan pertama kali dengan lisensi
Creative Commons Attribution 4.0 International License.
Penulis dapat memasukan tulisan secara terpisah, mengatur distribusi non-ekskulif dari naskah yang telah terbit di jurnal ini kedalam versi yang lain, seperti: dikirim ke respository institusi penulis, publikasi kedalam buku, dan lain-lain. Dengan mengakui bahwa naskah telah terbit pertama kali pada MAMEN (Jurnal Manajemen).
