Exporting data from SQL server to PostgreSQL limited 100 records

79 Views Asked by At

I have a database in SQL Server, but now I must transfer to PostgreSQL.

I'm trying to the way:

  1. Right-click on the database
  2. Task/ExportData
  3. Choose the database input enter image description here
  4. Choose the database output enter image description here
  5. Choose 'Copy data from one or more tables or views'
  6. 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?

0

There are 0 best solutions below