Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

This forum does not allow new topics to be created, please use the v2 forum from now on.

  • Robert Stocks 6 posts 29 karma points c-trib
    Dec 14, 2011 @ 12:05
    Robert Stocks

    Database table creation fails in SQL CE 4 - with solution

    on Umbraco 4.7.1 with the SQL Compact Edition database, this package did not create it's database table

    I got it to work by changing the create table SQL in package.xml to 

    CREATE TABLE infocaster301 (
    NodeID int NOT NULL,
    OldUrl nvarchar(400) NOT NULL,
    IsCustom bit NOT NULL DEFAULT 0,
    IsRegex bit NOT NULL  DEFAULT 0,
    Message nvarchar(400) NULL,
    Inserted datetime NOT NULL  DEFAULT getdate(),
            CONSTRAINT PK_infocaster301 PRIMARY KEY ( NodeID ASC, OldUrl)

    just posting this here incase anybody else needs it.

  • Michael Boserup Hesselberg 4 posts 25 karma points
    Feb 07, 2012 @ 15:06
    Michael Boserup Hesselberg

    Thanks for sharing this Robert :D

  • Damian Green 452 posts 1433 karma points
    Dec 03, 2012 @ 17:59
    Damian Green

    Just tried this on ce4.0 and it didnt like the ASC in the pimary key.  

    Removed that and it worked just fine! :)


  • Jan Skovgaard 11242 posts 23411 karma points MVP 6x admin c-trib
    Mar 10, 2013 @ 16:42
    Jan Skovgaard

    This package is so nice and it would be ace if this was simply just fixed so one would not need to do the trick above when using CE SQL :)


Please Sign in or register to post replies

Write your reply to: