Error when deploying DB
Brian25
Posts: 6
This is the error i get. Any suggestions? I don't see LocalDB as a requirement for the deployment manager to work?
2014-08-11 10:35:49 -04:00 INFO Building dynamic schema change script
2014-08-11 10:35:53 -04:00 ERROR Error while executing job: Dynamic deployment failed
2014-08-11 10:35:53 -04:00 ERROR RedGate.Migrations.Core.Database.TemporaryDatabaseException: Dynamic deployment failed ---> RedGate.Migrations.Core.Database.TemporaryDatabaseException: <html><body><p>Couldn't create a temporary database on LocalDB. Make sure LocalDB is installed. For more information, see <a href="http://www.red-gate.com/localdb">Downloading and installing LocalDB</a>.</p></body></html> ---> System.Data.SqlClient.SqlException: Directory lookup for the file "C:\Windows\system32\config\systemprofile\AppData\Local\Temp\Redgate\Red Gate\TempDb\rgtmpFC50Aug11.mdf" failed with the operating system error 3(The system cannot find the path specified.).
2014-08-11 10:35:53 -04:00 ERROR CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
2014-08-11 10:35:49 -04:00 INFO Building dynamic schema change script
2014-08-11 10:35:53 -04:00 ERROR Error while executing job: Dynamic deployment failed
2014-08-11 10:35:53 -04:00 ERROR RedGate.Migrations.Core.Database.TemporaryDatabaseException: Dynamic deployment failed ---> RedGate.Migrations.Core.Database.TemporaryDatabaseException: <html><body><p>Couldn't create a temporary database on LocalDB. Make sure LocalDB is installed. For more information, see <a href="http://www.red-gate.com/localdb">Downloading and installing LocalDB</a>.</p></body></html> ---> System.Data.SqlClient.SqlException: Directory lookup for the file "C:\Windows\system32\config\systemprofile\AppData\Local\Temp\Redgate\Red Gate\TempDb\rgtmpFC50Aug11.mdf" failed with the operating system error 3(The system cannot find the path specified.).
2014-08-11 10:35:53 -04:00 ERROR CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Comments
LocalDB is required if you are using the Migrations v2 beta feature. See this documentation page for more details: http://documentation.red-gate.com/display/SOC3/Packaging+V2+migration+scripts+for+Deployment+Manager
Redgate Software