# IT:AD:EF/CodeFirst/Migrations:HowTo:Generate SQL Scripts #



<callout type="Navigation" class="small">

* [[../|(UP)]]
{{indexmenu>.#2|nsort tsort}}

* See:
    * [[IT/AD/Code First/Migrations/HowTo/Update-Database]]


</callout>


<panel title="Summary">



</panel>


## Process ##

Run the [[IT/AD/Code First/Migrations/HowTo/Update-Database]] command, but this time, adding the `-script` switch so that the changes are output as a sql script, *rather than being applied*.



### Generate a Full Script

<sxh powershell>
</sxh>

### Generate an Incremental Script From X to Y


We’ll also specify a source and target migration to generate the script for. We want a script to go from an empty database ($InitialDatabase) to the latest version (migration AddPostAbstract).


<sxh powershell>
Update-Database -startupprojectname:App.AppHost.Web -projectname:App.Infrastructure -Script -SourceMigration: $InitialDatabase -TargetMigration: OurNamedMigration
</sxh>

### Generate an Incremental Script from last Applied Migration till Now

Probably the most used scenario:

<sxh powershell>
Update-Database -startupprojectname:App.AppHost.Web -projectname:App.Infrastructure -Script
</sxh>

>Note:
>Omitting SourceMigration means Last Applied In Db, and omitting TargetMigration means Current Code Model.

## Notes ##

`$InitialDatabase` appears to be a keyword...