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
1

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
  • Erica

    Hi Max,

    Dealing with seat counts and server licenses can be such a headache sometimes. Definitely check the license portal to make sure the old machine released the activation properly—otherwise you get stuck in activation limbo. 

    Hope you got it sorted out!

    Slope

    Erica
    -1

Add comment

Please sign in to leave a comment.