Penerapan Database Impor dan Ekspor Menggunakan SQL Server 2008

Authors

  • Yuda Mahendra Hasibuan Universitas Islam Negeri Sumatera Utara
  • Muhammad Irwan Padli Nasution Universitas Islam Negeri Sumatera Utara

DOI:

https://doi.org/10.55123/mamen.v2i3.2043

Keywords:

Diagrams, Export Import, Tutorial, Relations, SQL Server 2008

Abstract

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

Download data is not yet available.

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

2023-07-28

How to Cite

Yuda Mahendra Hasibuan, & Muhammad Irwan Padli Nasution. (2023). Penerapan Database Impor dan Ekspor Menggunakan SQL Server 2008. MAMEN: Jurnal Manajemen, 2(3), 327–334. https://doi.org/10.55123/mamen.v2i3.2043

Issue

Section

Articles