How to restore latest AdventureWorks database in psotgresql using pgadmin4?

27 views Asked by At

I have downloaded the backup file from Microsoft website for AdventureWorks database which has an extension of .bak.

Now I want to restore it in my postgresql 16.2 using pgadmin4 8.2 version.

While restoring I am getting below error. It seems that we cannot restore .bak file and that we need only .tar file.

Is there any way where I can restore the database and practice SQL queries ?

I tried restoring it with there GUI but was not able to do so.

Error while restoring

Error Sceenshot :

pg_restore: error: input file does not appear to be a valid archive

0

There are 0 answers