Generate DB Migration test
SaaS Recman AB / Logopedjobb / Alingsås
2026-06-23
Visa alla logopedjobb i Alingsås,
Ale,
Vårgårda,
Lerum,
Bollebygd eller i
hela Sverige Visa alla jobb hos SaaS Recman AB i Alingsås,
Ale,
Göteborg,
Uddevalla,
Falköping eller i
hela Sverige Database Migration Test Suite
Test Case 1: Schema Creation
Objective: Verify that the migration creates all required tables with correct schema
Test Steps:Run the migration script on a clean database
Query the database schema to verify table existence
Validate column names, data types, and constraints
Expected Result: All tables are created with correct structurePass/Fail Criteria: Schema matches the migration specification exactly
Test Case 2: Data Migration
Objective: Ensure existing data is migrated correctly without loss
Test Steps:Populate source database with test data
Execute migration script
Compare row counts between source and target
Verify data integrity and relationships
Expected Result: All data is transferred accurately with maintained relationshipsPass/Fail Criteria: 100% data accuracy with zero data loss
Test Case 3: Rollback Functionality
Objective: Test the ability to rollback migration changes
Test Steps:Apply the migration
Execute the rollback script
Verify database returns to previous state
Check data integrity after rollback
Expected Result: Database is restored to pre-migration statePass/Fail Criteria: Complete restoration without data corruption
Test Case 4: Index Creation
Objective: Validate that all indexes are created properly
Test Steps:Run migration script
Query database for index information
Verify index names, columns, and types
Test query performance with indexes
Expected Result: All indexes exist and improve query performancePass/Fail Criteria: All specified indexes are present and functional
Test Case 5: Foreign Key Constraints
Objective: Ensure foreign key relationships are established correctly
Test Steps:Apply migration
Attempt to insert data violating foreign key constraints
Verify constraint enforcement
Test cascading updates and deletes
Expected Result: Foreign key constraints are enforced properlyPass/Fail Criteria: Constraint violations are rejected, cascading works as expected
Test Case 6: Migration Idempotency
Objective: Verify migration can be run multiple times safely
Test Steps:Run migration script once
Run the same migration script again
Check for errors or duplicate objects
Verify data integrity
Expected Result: Second run completes without errors or duplicatesPass/Fail Criteria: Migration handles re-execution gracefully
Test Case 7: Performance Testing
Objective: Measure migration execution time and resource usage
Test Steps:Prepare database with production-like data volume
Monitor CPU, memory, and disk I/O during migration
Record execution time
Compare against performance benchmarks
Expected Result: Migration completes within acceptable timeframePass/Fail Criteria: Execution time meets performance requirements
Test Case 8: Default Values
Objective: Verify default values are set correctly on columns
Test Steps:Run migration
Insert rows without specifying default columns
Query inserted data to verify defaults
Test various default value types
Expected Result: Default values are applied automaticallyPass/Fail Criteria: All default values match specification
Så ansöker du Sista dag att ansöka är 2026-07-23
Klicka på denna länk för att göra din ansökan Omfattning Detta är ett heltidsjobb.
Arbetsgivare SaaS Recman AB (org.nr 559171-5643),
https://www.google.com/ 738 28 CITY
Körkort För detta jobb krävs körkort.
Arbetsplats Oscars Interim AB
Kontakt DEV
Ivanna Menchak
i.menchak+se@recman.io Jobbnummer 9975288