SQL Server to SQL Server Compact Edition Database Copy Utility

• Remove unavailable projects
• Remove unavailable referenced assemblies (Microsoft.SqlServer.*)
• Adding references to Microsoft.SqlServer.* assemblies
  located in %ProgramFiles%\Microsoft SQL Server\100\SDK\Assemblies
• Change the implementation of SelectMobileAssembliesDialog.Check35version() as described in comment:
  

  private bool Check35version(string path)
  {
    if (String.IsNullOrEmpty(path))
      return false;
   
    FileVersionInfo ver = FileVersionInfo.GetVersionInfo(path);
    if (ver.FileVersion == "3.5.8080.0")
    {
      _Ver35Valid = true;
      return true;
    }
    else
    {
      _Ver35Valid = false;
      return false;
    }
  }

See the end of this message for details 
 
on invoking 
just-in-time (JIT) debugging instead of 
 
this dialog box.
 
************** Exception Text 
 
**************
System.Reflection.TargetInvocationExcept
 
ion: Exception has been thrown by the 
target of an invocation. ---> 
 
System.ArgumentException: Invalid value 
for key 'locale identifier'.  ---> 
 
System.FormatException: Input string was 
not in a correct format.
   at 
 
System.Number.StringToNumber(String str, 
 
NumberStyles options, NumberBuffer& 
 
number, NumberFormatInfo info, Boolean 
 
parseDecimal)
   at System.Number.ParseInt32(String s, 
 
NumberStyles style, NumberFormatInfo 
info)
   at 
 
System.Data.SqlServerCe.ConStringUtil.Se
 
tIntType(String value, String key)
   --- End of inner exception stack 
 
trace ---
   at 
System.Data.SqlServerCe.ConStringUtil.Se
 
tIntType(String value, String key)
   at 
 
System.Data.SqlServerCe.ConStringUtil.Se
tLocale(Hashtable table)
   at 
 
System.Data.SqlServerCe.ConStringUtil.Ve
rifyValues(Hashtable values)
   at 
 
System.Data.SqlServerCe.ConStringUtil.Pa
rseConnectionString(String& 
 
connectionString)
   at 
System.Data.SqlServerCe.SqlCeEngine.set_
 
LocalConnectionString(String value)
   at 
 
System.Data.SqlServerCe.SqlCeEngine..cto
 
r(String connectionString)
   --- End of inner exception stack 
 
trace ---
   at 
System.RuntimeMethodHandle._InvokeConstr
 
uctor(Object[] args, SignatureStruct& 
 
signature, IntPtr declaringType)
   at 
 
System.RuntimeMethodHandle.InvokeConstru
ctor(Object[] args, SignatureStruct 
 
signature, RuntimeTypeHandle 
declaringType)
   at 
 
System.Reflection.RuntimeConstructorInfo
 
.Invoke(BindingFlags invokeAttr, Binder 
 
binder, Object[] parameters, CultureInfo 
culture)
   at 
 
System.RuntimeType.CreateInstanceImpl(Bi
 
ndingFlags bindingAttr, Binder binder, 
Object[] args, CultureInfo culture, 
 
Object[] activationAttributes)
   at 
System.Activator.CreateInstance(Type 
 
type, BindingFlags bindingAttr, Binder 
binder, Object[] args, CultureInfo 
 
culture, Object[] activationAttributes)
   at GLT.SqlCopy.WizardForm.DoCopy()
   at 
 
GLT.SqlCopy.WizardForm.UpdateWizard()
   at 
 
GLT.SqlCopy.WizardForm.btnNext_Click(Obj
ect sender, EventArgs e)
   at 
 
System.Windows.Forms.Control.OnClick(Eve
ntArgs e)
   at 
 
System.Windows.Forms.Button.OnClick(Even
tArgs e)
   at 
 
System.Windows.Forms.Button.OnMouseUp(Mo
useEventArgs mevent)
   at 
 
System.Windows.Forms.Control.WmMouseUp(M
 
essage& m, MouseButtons button, Int32 
clicks)
   at 
 
System.Windows.Forms.Control.WndProc(Mes
sage& m)
   at 
 
System.Windows.Forms.ButtonBase.WndProc(
Message& m)
   at 
 
System.Windows.Forms.Button.WndProc(Mess
age& m)
   at 
 
System.Windows.Forms.Control.ControlNati
 
veWindow.OnMessage(Message& m)
   at 
 
System.Windows.Forms.Control.ControlNati
 
veWindow.WndProc(Message& m)
   at 
 
System.Windows.Forms.NativeWindow.Callba
ck(IntPtr hWnd, Int32 msg, IntPtr 
 
wparam, IntPtr lparam)
 

************** Loaded Assemblies 
 
**************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/Microsoft.NET/Framewo

rk/v2.0.50727/mscorlib.dll
----------------------------------------
GLT.SqlCopy
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: 
 
file:///C:/Documents%20and%20Settings/la

xmi/Desktop/SQL2005%20express%20ToSQLCom
 
pact%20Convert/GLT.SqlCopy.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_MSIL/Sys

tem.Windows.Forms/2.0.0.0__b77a5c561934e
 
089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_MSIL/Sys

tem/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_MSIL/Sys

tem.Drawing/2.0.0.0__b03f5f7f11d50a3a/Sy
 
stem.Drawing.dll
----------------------------------------
Accessibility
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_MSIL/Acc

essibility/2.0.0.0__b03f5f7f11d50a3a/Acc
 
essibility.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_MSIL/Sys

tem.Configuration/2.0.0.0__b03f5f7f11d50
 
a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_MSIL/Sys

tem.Xml/2.0.0.0__b77a5c561934e089/System
 
.Xml.dll
----------------------------------------
Microsoft.SqlServer.Smo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.4035.00
    CodeBase: 
 
file:///C:/WINDOWS/assembly/GAC_MSIL/Mic

rosoft.SqlServer.Smo/9.0.242.0__89845dcd
 
8080cc91/Microsoft.SqlServer.Smo.dll
----------------------------------------
Microsoft.SqlServer.ConnectionInfo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.4035.00
    CodeBase: 
 
file:///C:/WINDOWS/assembly/GAC_MSIL/Mic

rosoft.SqlServer.ConnectionInfo/9.0.242.
 
0__89845dcd8080cc91/Microsoft.SqlServer.
 
ConnectionInfo.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_32/Syste

m.Data/2.0.0.0__b77a5c561934e089/System.
 
Data.dll
----------------------------------------
Microsoft.SqlServer.SmoEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.4035.00
    CodeBase: 
 
file:///C:/WINDOWS/assembly/GAC_MSIL/Mic

rosoft.SqlServer.SmoEnum/9.0.242.0__8984
 
5dcd8080cc91/Microsoft.SqlServer.SmoEnum
 
.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_32/Syste

m.Transactions/2.0.0.0__b77a5c561934e089
 
/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 
 
(REDBITS.050727-1400)
    CodeBase: 
file:///C:/WINDOWS/assembly/GAC_32/Syste

m.EnterpriseServices/2.0.0.0__b03f5f7f11
 
d50a3a/System.EnterpriseServices.dll
----------------------------------------
Microsoft.SqlServer.SqlEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.4035.00
    CodeBase: 
 
file:///C:/WINDOWS/assembly/GAC_MSIL/Mic

rosoft.SqlServer.SqlEnum/9.0.242.0__8984
 
5dcd8080cc91/Microsoft.SqlServer.SqlEnum
 
.dll
----------------------------------------
Microsoft.SqlServer.BatchParser
    Assembly Version: 9.0.242.0
    Win32 Version: 2005.090.4035.00
    CodeBase: 
 
file:///C:/WINDOWS/assembly/GAC_32/Micro

soft.SqlServer.BatchParser/9.0.242.0__89
 
845dcd8080cc91/Microsoft.SqlServer.Batch
 
Parser.dll
----------------------------------------
System.Data.SqlServerCe
    Assembly Version: 9.0.242.0
    Win32 Version: 3.0.5300.0
    CodeBase: 
 
file:///C:/WINDOWS/assembly/GAC_MSIL/Sys

tem.Data.SqlServerCe/9.0.242.0__89845dcd
 
8080cc91/System.Data.SqlServerCe.dll
----------------------------------------
 
************** JIT Debugging 
 
**************
To enable just-in-time (JIT) debugging, 
 
the .config file for this
application or computer (machine.config) 
 
must have the
jitDebugging value set in the 
 
system.windows.forms section.
The application must also be compiled 
 
with debugging
enabled.
 
For example:
 
<configuration>
    <system.windows.forms 
 
jitDebugging="true" />
</configuration>
 
When JIT debugging is enabled, any 
 
unhandled exception
will be sent to the JIT debugger 
 
registered on the computer
rather than be handled by this dialog 
box.

if (datatype == SqlDataType.NVarChar || datatype == SqlDataType.NChar || datatype == SqlDataType.VarBinary) 
sb.Append(" (").Append(col.DataType.MaximumLength.ToString()).Append(") ");

                        if (col.DefaultConstraint != null && !String.IsNullOrEmpty(col.DefaultConstraint.Text))
                        {
                            // SQL Server CE 3.5 does not support function GETUTCDATE()
                            col.DefaultConstraint.Text = col.DefaultConstraint.Text.Replace("(getutcdate())", "(getdate())");
                            string def = col.DefaultConstraint.Text.Replace("((", "(").Replace("))", ")");
 
                            sb.Append(" DEFAULT ").Append(col.DefaultConstraint.Text);
                            //sb.Append(" DEFAULT (1) ");
                        }

                                    // Check If Multi-Column Key's => Iterate Keys
                                    string createFKSql = String.Empty;
                                    if (sourceDb.Tables[fk.ReferencedTable].Indexes[fk.ReferencedKey].IndexedColumns.Count == 1)
                                    {
                                        // Single PK so use the original string
                                        createFKSql = String.Format(fkSql, tbl.Name, fk.Name, "{0}", fk.ReferencedTable, sourceDb.Tables[fk.ReferencedTable].Indexes[fk.ReferencedKey].IndexedColumns[0].Name);
                                    }
                                    else if (sourceDb.Tables[fk.ReferencedTable].Indexes[fk.ReferencedKey].IndexedColumns.Count > 1)
                                    {
                                        // Multi-Column PK
                                        createFKSql = String.Format(fkSql, tbl.Name, fk.Name, "{0}", fk.ReferencedTable, "{1}");
                                        string referencedColumns = String.Empty;
                                        foreach(IndexedColumn iCol in sourceDb.Tables[fk.ReferencedTable].Indexes[fk.ReferencedKey].IndexedColumns)
                                        {
                                            // Separate Columns including the square brackets
                                            // to identify each referenced column.
                                            if (referencedColumns.Length > 0)
                                                referencedColumns = referencedColumns + "], [";
 
                                            referencedColumns = referencedColumns + iCol.Name;
                                        }
                                        createFKSql = String.Format(createFKSql, "{0}", referencedColumns);
                                    }
                               
                                    StringBuilder sbFk = new StringBuilder();
                                    foreach (ForeignKeyColumn col in fk.Columns)
                                    {
                                        // Added square brackets to identify each column.
                                        if (sbFk.Length > 0)
                                            sbFk.Append("], [");
 
                                        sbFk.Append(col.Name);
                                    }