I need to generate a SQL update command in a *.sdf file.
The *.sdf file is deployed using Visual studio. I am looking to generate a script which fills in a table the maximum number of records which is about 2MBytes.
any ideas for how I can do this i.e. connect remotely to the database and script filling in the database with a dummy record? Examples and deployment would be fab :-)