Cara menggunakan synchronize model mysql workbench

How to synchronize two databases by using MySQL Workbench - MySQL DBA Tutorial

How to synchronize two  databases by using MySQL Workbench

MySQL Workbench Tutorial - Synchronize two Databases in MySQL Servers by using Workbench

Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest

Di artikel sebelumnya kita sudah mencoba untuk melakukan forward engineering, sekarang kita akan mulai melakukan kebalikannya. Mungkin buat yang sebelumnya lebih suka mengotak-atik database MySQL secara langsung tidak menggunakan diagram, akan merasa kesulitan jika ingin mempresentasikan design databasenya ke orang lain, karena tentu tidak mungkin misalnya kita ingin mempresentasikan database yang kita buat ke bos menggunakan phpmyadmin / MySQL administrator, hehe bisa dilempar asbak ntar.

Reverse Engineering

Okeh kita mulai saja tahap untuk reverse engineering, lakukan langkah berikut:

1. Jalankan MySQL Workbench
2. Klik Create EER Model from Existing Database di kolom Data Modelling
3. Akan muncul tampilan untuk memilih koneksi database, pilih koneksi localhost di Stored Connection yang sudah dibuat sebelumnya
4. Klik tombol Next
5. Klik tombol Next lagi setelah proses selesai
6. Pilih database-database yang ingin di reverse engineer, untuk sekarang pilih database test_db yang sudah kita buat sebelumnya, lalu pencet Next
7. Klik tombol Next lagi setelah proses selesai
8. Klik Next lagi……… smoga pembaca gak bosen-bosen buat pencet tombol next, next, next hehe
9. Akan muncul tampilan seperti di bawah ini:
   
   
10. Untuk sekarang kita tidak perlu mengotak-atik apa-apa langsung saja klik tombol Execute
11. Setelah proses selesai klik tombol Next, lalu klik tombol Finish

That’s it hehe, gak sulit untuk melakukan reverse engineer di MySQL Workbench kan. Anda sekarang bisa men-save diagram ER hasil reverse engineering.

Sinkronisasi Database

Sekarang kita akan mencoba untuk melakukan sinkronisasi antara database yang ada di server MySQL kita dengan diagram EER yang kita buat di MySQL Workbench. Dengan melakukan ini kita tidak perlu lagi untuk melakukan update manual di database MySQL kita ketika kita mengubah diagram EER dari database tersebut.

Untuk melakukan hal ini tidaklah rumit, anda cukup membuka diagram EER yang ada lalu klik Database -> Synchronize Model di menu. Cukup klik next, next, next seperti biasa maka database anda akan terupdate sesuai dengan perubahan yang ada di diagram.

The defense attorney representing the suspect in the University of Idaho murders is facing questions from legal experts about a potential conflict of interest as she also represented Cara Northington, the mother of one of the victims, in separate criminal cases.

Brian Kohberger, 28, a Ph.D. student in criminal justice and criminology at Washington State University, has been charged with four counts of first-degree murder and burglary in connection with the killings of Madison Mogen, Kaylee Goncalves, Xana Kernodle and Ethan Chapin in Moscow, Idaho.

The Idaho Statesman previously reported that Anne Taylor represented Northington, the mother of Kernodle, in four separate cases. NewsNation also reported on Friday that two other parents of two of the victims had also been represented by Taylor.

The only one of the parents we know Taylor has represented is Northington —who is also known as Cara Kernodle. Here's what we know about what charges she faces.

The Charges Facing Cara Northington

Less than a week after the Idaho murders took place, drug charges were filed against Northington, Fox News reported. On November 19, she was arrested in Kootenai County. She is charged with two felony counts for possession of a controlled substance and is listed on Kootenai County Sheriff's Office's "Active Wanted Persons."

As well the felony counts, she also represented Northington on a misdemeanour charge from August 2017, which has since been adjudicated, according to The Idaho Statesman.

Northington told NewsNation that Taylor, the chief of the Kootenai County Public Defender's Office, suddenly withdrew from representing her in the unrelated drug charge on January 5, according to court documents. That same day, Kohberger, who is accused of fatally stabbing Kernodle and three others on November 13, had his first court appearance at Latah County Courthouse with Taylor by his side.

Taylor is now listed as an "inactive" attorney on the cases where she represented Northington.

Cara Northington—told NewsNation that she was "heartbroken" and "betrayed" by Taylor representing the suspected killer of her daughter.

Newsweek has contacted Taylor for comment.

Read more

• Cara Kernodle reveals how she reconnects with murdered daughter Xana
• How Bryan Kohberger could lose his lawyer
• Cara Kernodle reveals death penalty stance for daughter Xana's killer

Several legal and criminal case experts questioned Taylor's change to represent Kohberger and said it likely represents a conflict of interest.

"Can't understand how a conflict of interest didn't exist when AT took the case. IME w/the Public Defenders Office, when their office represented a client associated with a case they could NOT except the client," tweeted law enforcement analyst and ex-FBI agent Jennifer Coffindaffer.

"Have never seen a conflict like this overlooked by a court," she added.

"The mere fact that the public defender was forced to make a decision about which client to represent reflects a potential issue of competing loyalties," Michael McAuliffe, a former federal prosecutor and elected state attorney, told Newsweek.

McAuliffe said Taylor "is surely acting in good faith, trying to navigate the applicable ethical obligations," but the potential conflict of interest is "significant."