How to setup initial data in database


I have created an Entity Relationship Diagram. I can generate database from it by the Wizard, but I dont know how can I setup default data in the database.
If I add some INSERT INTO thing to the generate DLL, than I dont know have can I regenerate the database again, or synchronize to the Entity Relational Diagram. If I regenerate the database by the wizard again, my changes will be overwritten.
Does anybody know how can I solve this problem?


Hello Bela,

Thank you for your message. The generated DDL is only for creating database’s structure but not for inserting data. For creating initial data, you can create another script for the insert statement and execute it manually, or using program to insert the sample data. We will consider support defining initial data in diagram and generate in DDL in the future. If you need any help, please do not hesitate to contact me again.

Best regards,
Rain Wong