How can we help you today? How can we help you today?

SQL Packager: Foreign key constraint problem

I've packed a database structure and data to create a new database. The database has been packed into a .NET executable.

When creating the new database, the script aborts with SQL Error:

'FK_Vendor_Portals' is not a constraint.
Could not drop constraint. See previous errors.

SQL Packager tries to DROP foreign keys which are named starting 'FK_'.

[....]
BEGIN TRANSACTION
ALTER TABLE [dbo].[Vendors] DROP CONSTRAINT [FK_Vendor_Portals]
ALTER TABLE [dbo].[VendorClassification] DROP CONSTRAINT [FK_VendorClassification_Classification]
[....]

The contraints used in the source database are named 'DF_'.

Where is this name coming from?
Apoc
0

Comments

2 comments

Sort by
  • david connell
    Hi Thomas,
    Can you backup the problematic database, zip it up and e-mail it to me at david.connell@red-gate.com please? That will help us troubleshoot the problem.

    -David
    david connell
    0
  • Apoc
    Everything's fine now. It works.
    Apoc
    0

Add comment

Please sign in to leave a comment.