Sql Server export did not include all tables

Jun 30, 2011 at 7:21 PM

This program looks very useful to me, but I'm afraid I had some trouble with it.  I installed ver. 6.0.0.0, running on Windows 64.  Then I exported a database from Sql Server 2005.  It seemed to work fine (there was no indication of any error), but some of the tables were not included in the CE database.  Some of the missing tables are in the dbo schema; all tables from other another schema were missing.  The tables that were included in the export appeared correct.  The server database has 82 tables, but I only got 71 in my export.

 

Jul 1, 2011 at 4:08 PM

I found the trouble.  The tables that didn't come through had columns of type "text".  After changing them to type "nvarchar(MAX)", the import worked.