Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Where to install
Options
Previous Topic Next Topic
JWB
#1 Posted : Sunday, 5 June 2011 5:46:32 PM(UTC)
Rank: Member

Joined: 31/05/2011(UTC)
Posts: 29
Man
Location: Seattle
I've got a question regarding where to install. What I mean is can GSPro be installed on my home office computer and once complete the entire thing UpLoaded to the Web server. Do any changes need to be made to GSPro once it resides on the Web Server. Once UpLoaded to the Web Server I presume I can then upload images onto the server (ftp). Also does the database live on the Web Server. I have read the manual but these points are a little foggy to me. Thanks.

John
Back to top
WWW
Roger Martin
#2 Posted : Sunday, 5 June 2011 8:39:13 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
The answer depends on which database you use:

SQLite - The data is contained in a file in the App_Data directory, so when you copy the files to the server, you copy the data, too. This is the easiest way to move a gallery and its data.

SQL Server - The data is stored in SQL Server, which can be stored anywhere, but it is often stored on the web server. When you move a gallery, you have to migrate the database, too, and possibly update the connection string in web.config. If you are not comfortable with SQL Server, consider sticking with SQLite or spending some time "getting to know" SQL Server.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
JWB
#3 Posted : Sunday, 5 June 2011 10:52:32 PM(UTC)
Rank: Member

Joined: 31/05/2011(UTC)
Posts: 29
Man
Location: Seattle
When version 2.5, due later this month with SQL Compact CE, will that be the the same thing as using SQLite?

John
Back to top
WWW
Roger Martin
#4 Posted : Monday, 6 June 2011 7:35:54 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
Yes.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
JWB
#5 Posted : Monday, 6 June 2011 1:29:44 PM(UTC)
Rank: Member

Joined: 31/05/2011(UTC)
Posts: 29
Man
Location: Seattle
Another item...even though I'm waiting for Ver2.5 I noticed when the Web installer is run for Ver2.4 when it gets to the screen (first screen I think)the only choice is SQL Server. Looking at the manual the same screen shows a choice between SQL Server or SQL Lite. I may be looking at the wrong part of the manual but I thought I would mention it just in case. By the way, I think you are doing a great job answering all these questions on this forum. Some forums one is lucky if one gets a reply within a week. Thank you.

John
Back to top
WWW
Roger Martin
#7 Posted : Monday, 6 June 2011 2:01:41 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
The WPI only supports SQL Server in 2.4. In 2.5 the WPI will support SQL Compact CE (and possibly SQL Server, too - that decision has not yet been made).

The stand-alone versions include a different installer that lets you choose which database you want (SQLite/SQL Server for 2.4 and SQL CE/SQL Server for 2.5).
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
JWB
#8 Posted : Monday, 6 June 2011 6:12:21 PM(UTC)
Rank: Member

Joined: 31/05/2011(UTC)
Posts: 29
Man
Location: Seattle
Thank for the information. I'm learning slowly but surely.

John
Back to top
WWW
Shandra
#6 Posted : Monday, 13 June 2011 11:03:33 PM(UTC)
Rank: Newbie

Joined: 13/06/2011(UTC)
Posts: 1
Location: byserg
JWB;7247 wrote:
Another item...even though I'm waiting for Ver2.5 I noticed when the Web installer is run for Ver2.4 when it gets to the screen (first screen I think)the only choice is SQL Server. Looking at the manual the same screen shows a choice between SQL Server or SQL Lite. I may be looking at the wrong part of the manual but I thought I would mention it just in case. By the way, I think you are doing a great job answering all these questions on this forum. Some forums one is lucky if one gets a reply within a week. Thank you.
John

will that be the the same thing as using SQLite?
Back to top
WWW
 |  Edit by moderator
Roger Martin
#9 Posted : Tuesday, 14 June 2011 6:23:06 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
Yes, using SQL CE is much like using SQLite, plus added benefits of working in medium trust, a single version for both 32 and 64-bit servers, and enforced data typing and referential integrity.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET