Generate Schema and Data to SQL script and Run it on another DB programmatically

I can manually generate a schema with data via Table Name > Tasks > Generate Scripts...

But it is possible to create a schema+data single sql file backup of a database and run it on another database programmatically ?

Maybe some SQL Script which will be scheduled by Job or by another approach, i dont know.

Thank you