StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Database Deployment Toolkit
»
Issues
»
Database Deploymen Toolkit Failing to change PK data type
Database Deploymen Toolkit Failing to change PK data type
Post Reply
Like
2
Database Deploymen Toolkit Failing to change PK data type
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Donovan Sobrero
Donovan Sobrero
posted 16 Years Ago
ANSWER
HOT
Topic Details
Share Topic
Group: Forum Members
Posts: 17,
Visits: 78
We have an ERP software package with a number of database definiitons that we are hoping to correct. We're trying to use the Database Deployment Toolkit to deploy new definitions to our legacy databases used in the field by our customers. Our first attempt at converting the database schema to an updated schema has not been very sucessful. Primarily, one of the issues that is trying to be corrected is converting PK datatypes from Decimal(10,0) to Int. It appears based on the log error messages that the PK constraints are not dropped prior to the type change being applied.
Is this something that the tool is meant to support?
Thanks,
Aaron
Reply
Like
2
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Database Deploymen Toolkit Failing to change PK data type
Donovan Sobrero
-
16 Years Ago
Generally databases that have been updates with the DDT were initially...
Trent L. Taylor
-
16 Years Ago
How do we go about getting this to you (sorry, newbie here)? What do...
Donovan Sobrero
-
16 Years Ago
You can just post it as an attachment here on the forum if you are...
Trent L. Taylor
-
16 Years Ago
Here is the pkgfile.
Donovan Sobrero
-
16 Years Ago
Here is a backup of the SQL db.
Donovan Sobrero
-
16 Years Ago
You did not attach your SQL Server backup.
Trent L. Taylor
-
16 Years Ago
I have tried to attach both a .rar and .zip but the browser keeps...
Donovan Sobrero
-
16 Years Ago
Sounds good.
Trent L. Taylor
-
16 Years Ago
OK...you have a massive database which made it difficult to even test...
Trent L. Taylor
-
16 Years Ago
Hello, I tried to run the pkg you post and am still seeing errors...
Donovan Sobrero
-
16 Years Ago
This issue has nothing to do with you decimal to integer stuff. You...
Trent L. Taylor
-
16 Years Ago
heh, I cant count the number of times I forgot to check that since is...
Keith Chisarik
-
16 Years Ago
Yeah, it happened to me the other day too...so we are going to add a...
Trent L. Taylor
-
16 Years Ago
Hello, How do I do this: So if you deleted a file group, database,...
Donovan Sobrero
-
16 Years Ago
First, download the latest 1.6.5 beta, it will tell you where all of...
Trent L. Taylor
-
16 Years Ago
Post Reply
Like
2
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search