| Author |
 Topic  |
|
|
sethrpg
2 Posts |
 Posted - 10/09/2009 : 14:02:06
|
HeyHey.
DB Ghost Packager Plus isn't building.
I'm just using the trial version to test out.
Here are the errors. Hopefully you can help out and make a sale.
Cannot create user '[username]
->Cannot create user '[username]
->The login already has an account under a different user name.
Cannot create table [dbo].[dtproperties]
->Cannot create table [dbo].[dtproperties]
->An item with the same key has already been added
Cannot create foriegn key [dbo].[reportDetail]. [FK_reportDetail_Parentreport]
->The ALTER TABLE statment conflicted with the FOREIGN KEY
constraint "FK_reportDetail_parentreport".
The conflict occured in database "DBUpgrade"
Cannot insert data in dbo.report. some part of your SQL statment is nested to deeply.
->Cannot insert data in dbo.report. some part of your SQL statment is nested to deeply.
Re-write the statment or break it up into smaller queries.
Cannot create key [dbo].[dtproperties].[pk_dtproperties]
->Cannot create key [dbo].[dtproperties].[pk_dtproperties]
->[dbo].[dtproperties] does not exist.
Also we are using SQL Server 2005, if that helps at all.
|
|
|
leachm
124 Posts |
Posted - 10/10/2009 : 08:43:08
|
Hi,
There appear to be a few issues in there - could you send a zip of the source database and the Packager Plus project xml file to support@innovartis.co.uk please?
In general, though, the dtproperties table is for schema diagrams under SQL 2000, not SQL 2005 - are you sure you're using SQL 2005 for the source and target databases?
Thanks,
Malcolm |
Edited by - leachm on 10/10/2009 08:43:55 |
 |
|
|
sethrpg
2 Posts |
Posted - 10/13/2009 : 15:32:52
|
Okay, we solved most of the errors.
We DO in fact have SQL 2005. But there is a 2000 compatibility mode we set it to. So that should be mostly fine.
We dropped the dtproperties table, because we don't need that. So that bug is fixed.
The only one we have now is:
Cannot create user '[username]
->Cannot create user '[username]
->The login already has an account under a different user name.
This problem occurs even when we have "Users And Roles" unchecked.
We do all of our Users, roles and permissions separately and don't need these things managed.
|
|
|
|
jon.woolgar
19 Posts |
Posted - 10/14/2009 : 03:07:23
|
Hi,
Could you possibly send a zip of the source database and the Packager Plus project xml file to support@innovartis.co.uk please? This will help us reproduce your problem and find a solution.
Regards Jon W
(Innovartis) |
|
|
| |
Topic |
|
|
|
DB Ghost Packager Plus isn't building.
