SQL Server to SQL Server Compact Edition Database Copy Utility

            if (ver.FileMajorPart == 3 && ver.FileMinorPart == 5)

            progressBar1.Maximum = Math.Max( value, max );
            progressBar1.Value = Math.Min( value, max );

                    foreach (Column col in tbl.Columns)
                    {
                        if (colIdx > 0)
                            sb.Append(", ");

                        sb.Append("[").Append(col.Name).Append("]").Append(" ");
                        int max = 0;
                        switch (col.DataType.SqlDataType)
                        {
                            case SqlDataType.NVarCharMax:
                                max = 4000;
                                col.DataType = new DataType(SqlDataType.NVarChar);
                                col.DataType.MaximumLength = max;
                                break;

     
case SqlDataType.SmallDateTime:
     max = col.DataType.MaximumLength;
     col.DataType = new DataType(SqlDataType.DateTime);
     col.DataType.MaximumLength = max;
     break;

void DoCopy()
{
    ...
    							
    string fkSql = "ALTER TABLE [{0}] ADD CONSTRAINT [{1}] FOREIGN KEY([{2}]) REFERENCES [{3}] ([{4}]) ON DELETE {5} ON UPDATE {6} ";
    ...
    string createFKSql = String.Format(fkSql, 
	tbl.Name, 
	fk.Name, 
	"{0}", 
	fk.ReferencedTable, 
	sourceDb.Tables[fk.ReferencedTable].Indexes[fk.ReferencedKey].IndexedColumns[0].Name,
	fk.DeleteAction.ToSql(), fk.UpdateAction.ToSql());

    ...
}

internal static class ForeignKeyActionExtensions
{
	public static string ToSql(this ForeignKeyAction action)
	{
		switch (action)
		{
			case ForeignKeyAction.Cascade: return "CASCADE";
			case ForeignKeyAction.NoAction: return "NO ACTION";
			case ForeignKeyAction.SetDefault: return "SET DEFAULT";
			case ForeignKeyAction.SetNull: return "SET NULL";
		}
		throw new InvalidEnumArgumentException("action", (int)action, typeof(ForeignKeyAction));
	}
}