I have a large database up to 159 GB. The database of SQL Server 2008 is saved on one machine. I don't have much knowledge about Import/Export wizard nor I have a secondary storage like pen drive which could store this 159 GB data to move database files from one machine to another. Is there any good option that I can use to migrate the database from SQL Server 2008 to 2014?
So, basically you want to upgrade SQL server to a newer version, correct?
i think you should post this question on a micorosft forum for better assistance.
As far as i know you can perform an in-place upgrade to SQL Server 2014 using the graphical Installation or you can upgrade using a configuration file.
If instead you want to install SQL on another machine and mugrate the database there i think you have to depoly the new machine, isntall SQL 2014 and follow the Micorosft best practices for the database migration.