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

SQL Packager

SQL Bundle Installation:

The Installation of the software on a Windows XP SP2 with Post SP2 Patches ran smoothly and without any problems.

SQL Packager:
Packaging a SQL 2005 database (Developer Edition Build 9.0.1399) sized 8MB for distribution (including schema and all data) came up with a SQL Packager Install executable of 540 KB. Thats amazing.

The installation throwed an error

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_AnonymousUsers_Portals". The conflict occurred in database "DNN4test", table "dbo.Portals", column 'PortalID'.

The textbox of the SQL Error windows does not support Ctrl-A to mark the text. A "Mark All" or "Copy to Clipboard" Button would be fine.


Testing will go on..

Thomas
Apoc
0

Comments

4 comments

Sort by
  • Tilman
    Hi Apoc,

    it seems like you are having a problem with dependencies. Could you please check that you have the 'Disable foreign keys' option enabled when you package your database. This option is a 'Data option' and can be found by going to Packager>SQL Options>Data.

    Thanks for pointing out the problem with the SQL Error window, we will incorporate a fix in the final release.
    Tilman
    0
  • Apoc
    Hi Tilman,

    the problem (and the error message) is still the same. Even after building a new Packager executable with the "Disable foreign key" option enabled.

    Thomas
    Apoc
    0
  • Neil Davidson
    Apoc,

    Can you backup the problematic databases, zip it up and e-mail it to me at neil.davidson@red-gate.com please? That will help us troubleshoot the problem.

    - Neil
    Neil Davidson
    0
  • Apoc
    Neil,

    the database is on its way :)

    Thomas
    Apoc
    0

Add comment

Please sign in to leave a comment.