Hoping someone may be able to advise what might be happening here. I am attempting to run an SSDT deployment via a Powershell script directly on the SQL Server its-self.
SQL Version: 2012 (upgrade not possible at the moment)
Exact error:
System.Management.Automation.MethodInvocationException: Exception calling "GenerateDeployScript" with "3" argument(s): "Version store out of memory (cleanup already attempted)" Microsoft.Isam.Esent.Interop.EsentVersionStoreOutOfMemoryException: Version store out of memory (cleanup already attempted)
All my research on the web has solutions for when this occurs through MSBuild, however I have no-where to apply the fix for this process as it happens outside of the build process.
Can anyone advise how one might prevent this from occuring? Thanks :)