need help.. new to sql server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

need help.. new to sql server

Author

Topic

iskoflores
Starting Member

4 Posts

Posted - 2008-10-02 : 02:17:00

Our company is planning to migrate to VB.net and database to SQL Server. (our system and database currently is VFP). We are in outsourcing business and one of our service is installing a program in client's workstation. This program is a clone of our main program that would generate reports for them. We update the data by sending them the dbf every now and then. Now if we migrate to Vb.net and sql server, (1.) do we need also to install sql server to our clients so that we can still give them a program that would generate reports for them????.(2.) do we need to purchase cals for every client(as now, we have over 100 clients) (3.) what sql version do we need to use. is it possible for the company to use an sql server 05 while the clients will be using sql express? (4.) what are the features of every sql editions. is mysql is designed for web dev only ?(5.) Could anyone give me an idea or link or anything that would help me understand how VB.net and sql will work together?? and lastly (6.) any tips for a newbie like me hehe thx in advance.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-02 : 02:39:33

vb.net ?

1. no
2. dont understand. If its connectivity ? depends on if its winforms or webforms, for webforms: No
3. depends on answer to number 2. If its webforms, u need to install connectivity tools
4. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
5. www.asp.net/learn
6. www.asp.net/learn

The links above are for webforms, If its winsforms you ask about, use http://windowsclient.net/

For comparison of the two
http://msdn.microsoft.com/en-us/library/5t6z562c.aspx

iskoflores
Starting Member

4 Posts

Posted - 2008-10-02 : 03:00:50

actually it is winform, so we will need to purchase cals for every client? is that practical? or we can use the sql free edition for the clients and the standard edition for the company.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-02 : 03:31:25

To be honest, am a web developer and dont know much about client licensing. Sorry

But I know, you have to "ONLY" install MS SQL on the server and client tools on the clients.

iskoflores
Starting Member

4 Posts

Posted - 2008-10-02 : 03:46:18

what do you mean by client tools ?
is it a tool included in ms sql package ?

tnx tnx

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-02 : 03:49:04

yes

iskoflores
Starting Member

4 Posts

Posted - 2008-10-02 : 21:30:45

ok tnx. i really appreciate your help :D