1) what character encoding do I need to use for the import.sql file: ISO-8859-1 or UTF-8
2) when you have master-child data to insert, what is the best way to do it?
since I am using MS-SQL database, the ID's will be generated by the database, so I must do this:
insert into ParentTable (field1, field2, ..) values (..) insert into Child Table (filed1, field2, .., ParentId) values (..., 1) insert into Child Table (filed1, field2, .., ParentId) values (..., 1) insert into ParentTable (field1, field2, ..) values (..) insert into Child Table (filed1, field2, .., ParentId) values (..., 2)
insert into ParentTable (id, field1, field2, ..) values (1, ..) insert into Child Table (id, filed1, field2, .., ParentId) values (1, ..., 1) insert into Child Table (id, filed1, field2, .., ParentId) values (2, ..., 1)is there a better way?