Error upgrading database from 2.2.1 to 3.0.4
Hi,
I hit error when upgrading my 2.2.1 database to 3.0.4 using the SQL Package application located under Gemini Database folder as below. Any ideas? Should I run the script manually? BTW, where could I get the upgrade instruction doc?
<SQLError Package="CounterSoftGeminiv301SampleDatabase"><Error>There is already an object named 'geminigetissuereportersforallprojects' in the database.</Error><Assembly>CounterSoftGeminiv301SampleDatabase</Assembly><Package>Package1.resx</Package><Batch>Batch642</Batch><SQL>
CREATE PROCEDURE geminigetissuereportersforallprojects
as
begin
SELECT b.projectid,a.firstname+N' '+a.surname AS fullname
FROM geminiusers a join geminiissues b on a.userid=b.reportedby
GROUP BY b.projectid,a.firstname+N' '+a.surname
ORDER BY fullname
end
</SQL></SQLError>
Thank you
chanmy8
· 1 |
|
Friday, August 15, 2008, 2:42:43 PM |