How can we help you today? How can we help you today?

SQL Change Automation - Baseline does not capture Partition Scheme/Function

Hi All,

When generating project scripts/repository from existing database SQL Change Automation does not generate Partition Scheme/Function (normally found in Storage folder).

I could not find any Project option allowing me to do that. Also scripts covering Tables does ignore existing Partition Function (automatically taken out of generated scripts).

How do I include Partition Scheme/Function in my project, so I can reference it when create tables via Migration Scripts?

Partition function should be part of repository and replicated when deploying a database for the first time on a new server.

Thank in advance,

Max 

Max
0

Comments

2 comments

Sort by
  • Dan Calver
    Official comment

    Hi Max,

    This is default behaviour for a SQL Change Automation project, to change this for your existing project, please edit the .sqlproj file in notepad, then if you paste this into the file it will allow you to script partition schemes/functions.

    <SyncOptionIgnoreDataspaces>False</SyncOptionIgnoreDataspaces>

    Example: 

     

     

    Dan Calver
  • Balthazar

    I've encountered similar issues with SQL Change Automation not capturing partition schemes and functions. One workaround is to manually include these objects in your project by adding them as pre/post deployment scripts. For measuring angles accurately during database design, I recommend the online Protractor tool. It's free, easy to use, and great for measuring angles accurately. Another approach is to create a separate script file for partition objects and reference it in your migration scripts. Thanks for sharing!

    Balthazar
    0

Add comment

Please sign in to leave a comment.