I am still evaluating the developer tools and have now found an issue in Packager 6.4
I have created a script I want to deploy to a client , i build the views in a database, i used SQL to create a script file with the 2 views in.
I package it all up and then test against another database name
I choose the database (not create) and it tells me the view already exists
There is already an object named 'vPrimaryEmails' in the database.
I checked and there is not.
I ran SQL Profiler and found the EXE issues 2 USE statements
SQL:BatchCompleted use [GM803] Red Gate Software -RPOViews Darren Darren-PC\\Darren 0 0 0 0 7200 68 2011-11-27 19:31:10.760 2011-11-27 19:31:10.760
SQL:BatchCompleted USE [RPO]
Red Gate Software -RPOViews Darren Darren-PC\\Darren 0 0 0 0 7200 68 2011-11-27 19:31:10.983 2011-11-27 19:31:10.983
GM803 is the selected database , RPO was the database the script uses...
Obviously the script needs the Use statement removed and it worked..
Problem is if you dont remember you can have a problem. I think packager should remove any USE statements?