On the company, many source of data will be maintained by the staff. This situation will impact difficulty for managing data like transaction data, personal data over cross platform. Pentaho is application that can deliver powerful Extraction, Transformation and Loading (ETL) capabilities using an innovative, metadata-driven approach. We can easily to migrate data form the […]
Today, I’ve problem with my database. When I try to export/backup a database, the following error is shown: [code] Cannot load from mysql.proc. The table is probably corrupted [/code] And that is happened because some error in mysql engine. I try to solve it with upgrade mysql engine. The following steps are: 1. Using command […]
Now I want to share about how to bulk data from CSV file to table on MS SQL Server. Pleas open your Microsoft SQL Server Management Studio. And then select the database that you want to update the data. [code] BULK INSERT <table name> FROM ‘<workspace>product.csv’ WITH ( FIRSTROW = <number of row on […]
Berikut code yang digunakan untuk melakukan reset auto increment [code] USE db-name GO DBCC CHECKIDENT (table-name, RESEED, 0) GO [/code]