Deployment of system

I am about to start developing a system using VB 2003 and SQL Server 2000. On my development computer, I am going to use MSDE for the database, which I guess I will later be able to export to my client's SQL server 2000.

Now, I am a bit worried. In my local computer, I can develop a system which runs locally very well. So, I am very sure I will be able to develop one for my client. But when I later deploy it to the client, it will have to run on a server and client machines.

My question is, how easy or complex is it to deploy such a system from my standalone platform to a client-server one. I have adequate experience developing stand-alone systems.

I am about to get started so please kindly give me ideas on the best path to take.

Hi there and welcome to client server development :-)

Its quite easy if you are developing on a MSDE and want to deploy that later on a Std / Ent Server. It is reduced to making a backup and restoring the backup on the server, normally that should be all except for the server users, which additionally have to be scripted and deployed.

BTW: If you want to deploy it on productional systems on Std / Ent Editions, why don′t you use SQL Server Dev Edition to develop the applications. It would be more comfortable for you and it would be a more soution-near development.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanx a lot for the info.

What I am about to develop is really a small system that would not warrant me going for any extra development tools more than what I have - cost is an issue.

You said that the database it is a matter of backup/restore. What about the VB application? Lets take the simplest example below.

Supposing I have a VB form bound to a datasource coming from some SQL Connection (localhost) on my development PC. The form will run on my computer because its connection is there.

Now, what happens if I take the above (app and database) to client-server environment. I restore the db on server and install app on client (?). But the connection in app is to localhost on my development PC. So it will not run in client-server until I modify the connection to point to the new server. Am I right or wrong?

|||Hi,

yes you are right, but that a point of configuration. I think right now you are using configurable settings in your application, so just add another setting to pass the servername, port etc. to the data source creator (or whatever you implemented).

The developer edition isn′t expensive at all. Should be available for 49$ (around),so developing on development edition will help you in many cases spending (/wasting) time for configuring something or getting a fst info from the server.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||Be blessed. I'll check out all your suggestions.