What is the process to migrate from 1.9.1 to latest version (2.x)?
Is it possible?

What is the process to migrate from 1.9.1 to latest version (2.x)?
Is it possible?

Sure it is possible
https://github.com/YAFNET/YAFNET/wiki/Upgrade-(from-Version-1.9.1.8-or-earlier) 

I tried to run the installer on against current database I have. The install started and it was stuck on running scripts. It will just keep showing progress icon for 5-10 minutes and never complete.

Is their a way to somehow run the db scripts manually against the database? scripts seems to be using placeholder, which are populated by installer.

I tried to run the installer on against current database I have. The install started and it was stuck on running scripts. It will just keep showing progress icon for 5-10 minutes and never complete.

Is their a way to somehow run the db scripts manually against the database? scripts seems to be using placeholder, which are populated by installer.

Yes you can run all scripts manually from the install\mssql folder

I ran sql scripts manually and found that following index creation is taking a lot of time. [dbo].[yaf_vaccess_group] table has large number of entries.
Is there a way to speed it up? Is the index required?


/****** Object: Index [yaf_vaccess_group_UserGroup] Script Date: 09/28/2009 22:30:55 ******/
IF NOT exists (select top 1 1 from sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[yaf_vaccess_group]') AND name = N'yaf_vaccess_group_UserForum_PK')
SET ARITHABORT ON
CREATE UNIQUE CLUSTERED INDEX [yaf_vaccess_group_UserForum_PK] ON [dbo].[yaf_vaccess_group]
(
[UserID] ASC,
[ForumID] ASC,
[AccessMaskID] ASC,
[GroupID] ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

Obviously you can.

---

Phone Accessory 
iPhone 6 case 

I ran sql scripts manually and found that following index creation is taking a lot of time. [dbo].[yaf_vaccess_group] table has large number of entries.
Is there a way to speed it up? Is the index required?

Yes. it's required because of performance downgrade, moreover when you have a lot of users. You can try to run scripts without it first.
The index can be added later from Run sql sub-section of admin section.
Try to comment SET ARITHABORT ON.
Make sure that the script file order is proper too.