How Are You Managing SQL Database Schema Changes and Deployments in Microsoft Fabric?
Hi everyone, I'm exploring how development teams manage database schema changes and production deployments when working with SQL databases in Microsoft Fabric. As applications evolve, developers frequently need to add columns, modify tables, update stored procedures, and introduce new database objects. The challenge is deploying these changes safely without losing existing data, breaking application queries, or creating inconsistencies between development and production environments. Microsoft Fabric supports Git integration, deployment pipelines, and SQL database projects, but I'm interested in how teams are implementing these capabilities in real development workflows. A few questions for the community: Source Control: Are you managing Fabric SQL database schemas using Git integration, SQL database projects, or manually maintained SQL scripts? Deployment Strategy: How do you promote schema changes between development, testing, and production environments while preserving existing data? Breaking Changes: What approach do you use when renaming columns, changing data types, or removing database objects that existing applications depend on? Automated Testing: Are you validating database changes through CI/CD pipelines, schema comparisons, or automated integration tests before deployment? Rollback and Recovery: How do you handle unsuccessful deployments, especially when changes involve both database structure and existing records? Team Collaboration: How do multiple developers manage parallel schema changes without introducing conflicts or unexpected deployment behavior? I'm particularly interested in practical experiences using Visual Studio Code, SQL database projects, Git integration, and Fabric deployment pipelines. For production environments, would you recommend database project-based deployments with automated validation, or smaller incremental SQL migrations managed through CI/CD? I'd appreciate any examples, best practices, or lessons learned from teams managing Fabric SQL databases in real applications. Thanks!A Typo about View in the explorer of Fabric SQL Database (Korean)
Hi Team, When I am working with views in the Fabric SQL database, I found a typo in the left explorer regarding views: “보기” We can see the “뷰”(View) in SQL Server Management Studio(SSMS). It is also labeled as “뷰”(View) in the template menu. That should be “뷰”. Korean English Thanks, Hong
MS Access Database and MicroSoft Decommissioning
Hi folks, We have the following version of the MS Access Database and we are not sure when MicroSoft is decommissioning this version of MS Access Database. We have the latest version of MicroSoft Application installed as a part of our environment but the actual MS Access Database is the following for one of the databases. Do we need to update this database called agen_dat to the latest version of database. We really appreciate your recommendations. Thank youLearning Database
Hello guys, Those who are new here or are learning basic - advance concepts for Data Warehouse, Power BI dashboard development , DAX, Power Query and SQL(Basic-Advance) and want help can please subsccribe my YouTube channel for much better understanding. I try to upload topics that is easily understandable and can clear the concepts. Kindly visit my channel watch the content and if you like consider subscribing to it for more such contents. It helps me and motivates me to work more hard on it. Link: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS Kind Regards, Poojara Data Analyst | MSBI Developer | Power BI Consultant Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
