B4J Tutorial Using Sql Server 2008 with Advance Project Management of Saif

Hi Members.

This is continuation of below post

My struggle and win with Advance Project Management of Saif

Hi Members, Warning: This a first post I have written so long that it may cure insomnia of members. I tagged this post as tutorial as it has guidance for solving errors as I found. First I will like to thank Saif to giving me this amazing product for free...

www.b4x.com

Trying to restore the given .bak file of below project, in my Sql Server 2008

Advance Project Management (Jira Alternative) : Source code

Hello everyone :) *Starting off by thanking the one and only @Erel for making this possible for every single one of us ❤ Today we would like to announce the most complete project management system The project contains : 1- Employee information 2- Departments Information 3- Leaves Requests 4-...

www.b4x.com

I faced error as below and explanation I found,

prob: Specified cast is not valid. (SqlManagerUI)

    solu: The Windows server version is irrelevant.  Your post sounded like you
    were trying to restore a SQL Server 2012 backup to SQL Server 2008, which
    won't work. IF you are trying to restore a native SQL Server 2008 backup, it
    should be okay.

Now without the tables the login screen will not proceed.

Never learnt to stop, I opened the mysql script given and pasted the create table sql in Query of Sql Server 2008. It gave error and I changed the sql till it created the table.
One by one I copied and pasted each table sql and made changes and created the tables. I have attached the changed sql file here, hoping it may benefit members who have lower version of Sql Server.

All tables are ready but login page does not proceed as the '[email protected]' data is not there.

I searched in .bas files and found the table and minimum columns required and inserted the data as below,

insert into EmployeeInformation (EmpID, EmailAdd, EmpPassword, EmployeeName, EmployeeSalary, IsMale, EmpDeptID, IsAdmin) values (1, '[email protected]', 'admin', 'Admin', 1, 1, 1, 1)

Lo and Behold ! Advance Project Management is up and running like a smooth cake on my database.
Am I happy ? Oh come on ! My name is Anand which means 'Happy'.
And I am now confident with Sql Server setting too

I like to thanks Erel too here as this gave me chance to learn and use B4J and its database features.



Regards,

Anand