I have a database in SQL Server, but now I must transfer to PostgreSQL.
I'm trying to the way:
- Right-click on the database
- Task/ExportData
- Choose the database input enter image description here
- Choose the database output enter image description here
- Choose 'Copy data from one or more tables or views'
- Notification success with a total of 4477 rows transferred enter image description here
But, when I check the database in PostgreSQL, I just have 100-row and I re-tried another table but it's always 100-row. Somehow it's limited results. Is there a more efficient way for large numbers of results?