Penjana SQL Migrasi
Terangkan perubahan skema dan dapatkan SQL migrasi up dan down yang sepadan untuk Postgres atau MySQL, termasuk susunan selamat bagi jadual yang sedang digunakan.
Alat ini berfungsi sepenuhnya dalam pelayar anda. Fail anda tidak pernah dimuat naik ke pelayan.
Developer
Migration SQL Generator
Frontend preview — no upload or external service.
Migration SQL
Up: ALTER TABLE orders ADD COLUMN customer_ref text; CREATE INDEX CONCURRENTLY idx_orders_customer_ref ON orders (customer_ref); Down: DROP INDEX and DROP COLUMN in reverse order.
How Penjana SQL Migrasi works
- Open Penjana SQL Migrasi and review the example state before entering your own values.
- Enter or select the information needed for Penjana SQL Migrasi.
- Review the result and adjust the inputs if you want to compare another case.
Describe a schema change and get matching up and down migration SQL for Postgres or MySQL, including the safe ordering for a live table. The interactive workspace runs in your browser, so you can review the result without creating an account.
FAQ
What is Penjana SQL Migrasi used for?
Describe a schema change and get matching up and down migration SQL for Postgres or MySQL, including the safe ordering for a live table.
Do I need an account?
No. The tool is available directly in the browser without an account or sign-up.
What should I do if the result looks unexpected?
Check the entered values and compare them with the guidance shown in Penjana SQL Migrasi. Use the result as a planning aid and verify important decisions independently.