Johnny certainly can code. Thanks bud, I had been using a some ad-hoc codesmith templates and a bit of dirty work to do this, but having stumbled upon your application I must thank you for your work.

Johnny,
I have not use your tool yet, but looking at your screen shots looks pretty good and feels like something is missing at microsoft, I designed a small database in compact using SQL 2005 and I could not create a script to save it, and my machine broke and could not recup any of it, I had to retype all the tables again, this will allow me to create the DB in SQL and be able to script it and save it as well as to convert it to Mobile. Excelent Idea you deserve an applause.
Thanks

Johnny,

Great nice little utility. It was a pain to do the DB design directly in Visual Studio and was about to make my own before I found yours (a much nicer and complete version).

I did find a minor problem. You only let user select ONE schema. In my case, my SQL 2005 database has several schema for different tables. I have select one schema at a time and then select the tables with the selected schema (The schema selection did not filter out tables that do not belong).

I suggest you add and " -- All schema ---" or blank item in the Schema combo list. Then you have to associate the schema name with tables.

Thanks a lot.


John

I also noticed that the cascading of the Foreign key became NO ACTION.

Johnny, Thanks for your Utility. i have a broblem about it, i don't know why.
i generate a new ce database by GLT.SqlCopy.exe, when i use SQL Server Management Studio to connect the database, it's failed.
the message is:
cannot connected to F:\SQL Data\SQLCE\AUTOsoft.sdf
Unspecified error [ 3505053,3004180,F:\SQL Data\SQLCE\AUTOsoft.sdf ] (SQL Server Mobile Edition ADO.NET Data Provider)

could you help me about this. thanks.

Does this application create the foreign key relationships? I tried using it and it didn't seem to create them and I looked at the code and I don't see it either.

thanks,
Bob

Build number of SqlCe changed, so the version was no longer recognized.

Changed SelectMobileAssembliesDialog.cs line 97 to if (ver.ProductMajorPart == 3 && ver.ProductMinorPart == 5)

Has anyone ever run this on Vista? I convert a 2005 SQL Server DB to a SQL Compact 3.1. On the PDA(PocketP2003 and Mobile 5.0) when I access (via Select statement) varchar columns that have numeric data (ie: 01ABC) they are not recognized (if column has only alpha it works ie:ABC). I have a similar program that does this as well. I downloaded your program to see if it was something in my code. Tried on Multiple Vista PC's with the same result. Works on XP.

Any Idea?
Thanks, Josh

This is the best post on this topic i have ever read.


Regards

ricky

I posted your blog to my facebook group


Regards

hanitz