The latest articles on DEV Community by reinny kimutai (@reinny_kimutai_4b1a5c2da8). https://dev.to/reinny_kimutai_4b1a5c2da8 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2966209%2F848ed4d8-1ab9-42ac-89d7-286a11aff213.png https://dev.to/reinny_kimutai_4b1a5c2da8 en reinny kimutai Sat, 22 Mar 2025 14:13:20 +0000 https://dev.to/reinny_kimutai_4b1a5c2da8/moving-data-from-mysql-to-postgresql-n75 https://dev.to/reinny_kimutai_4b1a5c2da8/moving-data-from-mysql-to-postgresql-n75 <p>Precise Steps to Transfer Data from MySQL to PostgreSQL using DBeaver:</p> <p><strong>1. Connect to MySQL in DBeaver</strong></p> <ul> <li>Open DBeaver.</li> <li>Click Database &gt; New Database Connection.</li> <li>Select MySQL, click Next.</li> <li>Enter: <ul> <li>Host: <code>sourcedb-vicclasses.j.aivencloud.com</code> </li> <li>Port: <code>19774</code> </li> <li>User: <code>avnadmin</code> </li> <li>Password: <code>AVNS_DSKQiqnqWhlGSqkqB-R</code> </li> <li>Database: <code>defaultdb</code> </li> </ul> </li> <li>Test connection and click Finish.</li> </ul> <p><strong>2. Connect to PostgreSQL in DBeaver</strong></p> <ul> <li> <strong>Database &gt; New Database Connection</strong>.</li> <li>Select <strong>PostgreSQL</strong>, click <strong>Next</strong>.</li> <li>Enter: <ul> <li>Host: <code>172.178.131.221</code> </li> <li>Port: <code>5432</code> </li> <li>User: <code>luxds</code> </li> <li>Password: <code>1234</code> </li> <li>Database: <code>warehouse</code> </li> </ul> </li> <li>Test connection and click Finish.</li> </ul> <p>**</p> <ol> <li>Export Data from MySQL**</li> <li>Right-click the MySQL table <code>houses_for_rent_reinny</code>.</li> <li>Select <strong>Export Data</strong>.</li> <li>Choose <strong>Database</strong> as target.</li> <li>Click Next.</li> </ol> <p><strong>4. Set PostgreSQL as Target</strong></p> <ul> <li>Select the PostgreSQL connection (<code>warehouse</code> DB).</li> <li>Choose the staging.house_for_rent_reinny table (or create if not exists).</li> <li>Make sure column mapping matches: <code>id</code>, <code>title</code>, <code>location</code>, <code>size</code>, <code>price</code>.</li> </ul> <p><strong>5. Configure Export Options</strong></p> <ul> <li>Check <strong>Truncate before load</strong> if you want to clear data first (optional).</li> <li>Make sure <code>ON CONFLICT DO NOTHING</code> option is respected (DBeaver might not natively support this; handle duplicates later if needed).</li> <li>Click Next.</li> </ul> <p><strong>6. Execute Transfer</strong></p> <ul> <li>Review preview.</li> <li>Click Start to transfer.</li> <li>Wait until data is loaded and verify completion message.</li> </ul> <p><strong>7. Verify in PostgreSQL</strong></p> <ul> <li>Right-click staging.house_for_rent_reinny table under PostgreSQL connection.</li> <li>View Data &gt; All Rows.</li> <li>Confirm data matches top 10 rows from MySQL.</li> </ul>