What are the challenges you face when working across database platforms? Take the survey

What actions generate the schema snapshot required for drift and deploy preview reports?

I want to get clear on what activities ensure that I get drift and deploy preview reports.  I'm currently executing New-DataBaseReleaseArtifact via PS script and get the following WARNING:
"No schema snapshot could be retrieved from the target d
atabase; no report will be generated until your next deployment."   Yet, I have deployed to this DB, although only through executing the TargetedDeploymentScript.sql via SSMS.  Are there certain conditions for creating the snapshot?  Thank you. -Peter

Best Answer

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    The dbo.__SchemaSnapshot table is only created if you release using the package.

    Since you have now started deployed using the package, you should now have this table in the target and this should work next time.
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools


Sign In or Register to comment.