Description

Database containing municipalities and states from Brazil on SQL and NoSQL DMBS. I use normaly to make validations on formularies from Laravel to web development, but can be used to mobile development and desktop or another finality.

CSV Folder

• municipios.csv Contain municipalities from Brazil.
• ufs.csv Contain states from Brazil.

• Whose DBMS i can import these datas: Some thing.

SQL Folder

• municipios.sql Contain municipalities from Brazil.
• ufs.sql Contain states from Brazil.

• Whose relational DBMS i can import these tables: MySQL, Postgres and similar.

NoSQL Folder

• municipios.json Contain municipalities from Brazil.
• ufs.json Contain states from Brazil.

• Whose non-relational DBMS i can import these collections: MongoDB and similar.

Import table to SQL database (MySQL)

1 - Click on New to create a database.

2 - Give a name to the database and click on Create button.

3 - With the table created and set go to Import.

4 - Click on Choose File button.

5 - Choose the desired file and click on Select button.

6 - The file was selected.

7 - Click on Import button to finish the import.

8 - Check the table ceps to see the imported datas.

9 - The import is done.

Import table to SQL database (Postgres)

1 - Click on Server to create a database.

2 - localhost -> Create -> Database.

3 - Give a name to the database and click on Save button.

4 - The database was created.

5 - database -> Restore.

6 - In Format choose Custom or Tar.

7 - In Filename click on Folder icon.

8 - Choose the file to import and click on Select button.

9 - Click on Restore button to finish import.

10 - The table municipios was imported.

11 - example -> Schemas.

12 - Schemas -> Tables.

13 - You will see the exported table municipios.

14 - Tables -> Query Tool.

15 - Verify the exported table municipios.

16 - The import was a success.

Import collection to NoSQL database (MongoDB)

0 - I'm using MongoDB Compass (GUI) to access with graphic interface, install first to follow the next step.

1 - You need create a database, click on + button.

2 - Give a name to database and also to the collection (would be the equivalent a table in NoSQL Database), after click on Create Database button.

3 - Click on Import data button.

4 - Choose the desired file and click Select button.

5 - Click on Import button.

6 - The collection was imported.