It's much better to use the db replication or excel import module.
Because there are several things you'll have to keep in mind when storing data in your database manually. You will have to replicatie the Runtime behaviour. These are the things I can think of at this moment (there might be other things I have forgotten)
When adding the records you have to make sure that the database is aware of the new records. When the Runtime inserts any new records it raises the sequences (the db name for autonr). In your description the sequence thinks it can start counting at 1 but there are already a lot of records in the table.
After adding all the records you have to look for the sequence and set the index to the new. Where to find and how to update the sequence varies per database. Just google 'alter sequence [dbtype]'
If you look in the table Bas refers to you'll find the name of the sequences, but the sequence names are pretty easy to read so you can guess which sequence belongs to which table.
Make sure all the values of your enumerations are identical to the Name of the enumeration in your modeler file. These names are case sensitive.
Keep in mind that the XAS stores your datetime values in UTC time. So when adding date's to your database think of the timezone in which your original values are stored and convert that time to UTC before/while adding them to the database.
Don't insert data manually in your database yourself. This is something you should let the server handle. There are plenty of ways to import data into your application.
This could be caused by an autonumber sequence that is being kept in a separate table. But the potential issues you could get here are numerous, since any data integrity checks done by your model are not being executed.
Edit: What it comes down to is that there is no guarantee data is saved in a way you expect, there are many things you can overlook when doing manual inserts like that. This could even change between different versions of Mendix. For example, the attribute sequences are now stored in
System_CB_AttributeSequences but this will be changed in 3.0.
With data integrity I mean checks in your model such as unique constraints or required constraints. Or things like associations that are filled in a way that doesn't correspond with your model.
I recommend using the database replication module you can find in the appstore.
Thanks Bas for your answer,but please :