I am thinking tools that are free exist to script data and structures from Standard SQL to SQL CE in proper format. I have an example below that describes what I am looking for. If there is an easier way to do this I would appreciate it.
ie instead of scripting data this way:
If Exists (Select 1....)
CE I would need something along these lines:
INSERT INTO Table VALUES (...)
WHERE NOT Exists (SELECT ........)
-- INSERT with Default value if not exist. Next, UPDATE it
UPDATE Table1 SET (...) WHERE Column1='SomeValue'