Migration Tools & Guides

-- Upload a SQL file to generate PostgreSQL schema
-- This tool will convert MySQL/SQL Server syntax to PostgreSQL

-- Example conversion:
-- MySQL: INT AUTO_INCREMENT
-- PostgreSQL: SERIAL

-- MySQL: DATETIME
-- PostgreSQL: TIMESTAMP

-- MySQL: TEXT
-- PostgreSQL: TEXT (same)

-- Upload your SQL file to see the converted schema here.

-- PostgreSQL Migration Script
-- Generated from MYSQL schema

-- Step 1: Create database and connect
-- createdb your_database_name
-- psql -d your_database_name

-- Step 2: Enable required extensions

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE EXTENSION IF NOT EXISTS "pgcrypto";
CREATE EXTENSION IF NOT EXISTS "pg_trgm";


-- Step 3: Create schemas (if needed)
-- CREATE SCHEMA IF NOT EXISTS your_schema;

-- Step 4: Run the converted schema
-- Upload a SQL file to generate PostgreSQL schema
-- This tool will convert MySQL/SQL Server syntax to PostgreSQL

-- Example conversion:
-- MySQL: INT AUTO_INCREMENT
-- PostgreSQL: SERIAL

-- MySQL: DATETIME
-- PostgreSQL: TIMESTAMP

-- MySQL: TEXT
-- PostgreSQL: TEXT (same)

-- Upload your SQL file to see the converted schema here.

-- Step 5: Create indexes for performance

-- Add performance indexes
-- CREATE INDEX CONCURRENTLY idx_table_column ON table_name (column_name);
-- CREATE INDEX CONCURRENTLY idx_table_search ON table_name USING gin(search_column gin_trgm_ops);


-- Step 6: Set up permissions
-- GRANT ALL PRIVILEGES ON DATABASE your_database_name TO your_user;
-- GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO your_user;
-- GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO your_user;

-- Migration completed successfully!