I have a database dump of 1 gb data,how do I ideally get this data into erpnext?
Are you trying to find out how the system handles a heap of totally unspecified data (other than its size and being some kind of a DB dump)?
No,not that ,is there any data migration tool
Sure, there are several ways to import data.
You can start creating the DocTypes (“models”, but with UI components rolled into them) and then: use the importers which are provided automatically for every doctype, or you talk to the tables via REST API, or use direct DB import into your doctypes via a mariadb console. If nothing helps, you can create scripts talking to DB via convenient libraries if data needs more treatment while importing.