René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Feature] Add Migration Support for MSSQL","articleBody":"**Is your feature request related to a problem? Please describe.**\n\nMigrations are a valuable feature for managing database schemas, but the lack of MSSQL support in the main sqlx crate means users of sqlx_oldapi miss out on this functionality. This creates challenges in achieving feature parity with other supported databases.\n\n**Describe the solution you'd like**\n\nI would like to confirm if implementing the `MigrateDatabase` and `Migrate` traits is sufficient to enable migration support for the MSSQL backend.\n\nA secondary component would be potentially enabling the macro support for `migrate!()` though I've not looked into if it uses the same underlying implementation as of yet.\n\nIf so, I'm happy to contribute an implementation, along with any necessary tests. \nI understand that testing for MSSQL can be troublesome at the best of time- and am aware it also  partially contributed to its removal from upstream. That being said- I'm down to give it a crack + any creating tests if/as needed.\n\n\n**Describe alternatives you've considered**\n\nNone applicable, upstream sqlx dropped MSSQL support some time ago.\n\n**Additional context**\n\nThe goal is to enable code like the following:\n\n```Rust\n        let (connection_timeout, idle_timeout, max_lifetime) = Self::pool_opts(config);\n\n        let client = sqlx::mssql::MssqlPoolOptions::new()\n            .idle_timeout(idle_timeout)\n            .max_connections(config.db_pool_total_connections() as u32)\n            .max_lifetime(max_lifetime)\n            .acquire_timeout(connection_timeout)\n            .connect(\u0026Self::format_connection_string(config)?)\n            .await?;\n\n        let migrator = sqlx::migrate::Migrator::new(std::path::Path::new(\"../../migrations\"))\n            .await?;\n        migrator.run(\u0026client).await?;\n```\n\nCurrently, this fails because the MSSQL implementation lacks the Migrate trait, which is required by run_direct (expecting C: Migrate).\n\nI'm eager to attempt this implementation, though I note that I have no prior experience with database backend implementations.","author":{"url":"https://github.com/MrDwarf7","@type":"Person","name":"MrDwarf7"},"datePublished":"2025-07-18T05:35:57.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/29/sqlx-oldapi/issues/29"}