On Sat, Dec 13, 2008 at 3:18 AM, Al <[email protected]> wrote: > Hi foxgang. > I'm used to vfp and its dbf's and know what to do about data when its user > defined where it goes. But .net and c# in particular I don't have a clue. > I was going to try out sql 2008 express but I'm not sure how to deal with > data on a server, or other workstation. It seems easier to use vfp like > tables where you ask the user to tell the program where they are. What are > others doing. I do not have the ability to maintain these systems. This is > why I'm not so sure about using sql server or mysql. Lack of knowledge. > Al -------------------------------------------
How to deal with data on a server? Let's try to give you the 30,000 ft concept of RDBMS. There is a server which has a service running on it for maintaining data. That Service exposes a set of APIs for you to work with that Service. 10,000 foot concept You connect to the service with a connection string in your case. This presents a set of credentials to the service that define who you are and what you are allowed to do. You could focus on maintenance like backup/restore, index tuning, schema modifications, constraints etc. Or you could work on Security aspects such as who has access to what or who will be able to deal with encrypted rules that apply to data. Last aspect you have available is consumption of the data held. Ground level view You will probably only deal with 2 situations. Need for data access or setup of the database. For data access you are going to execute statements or scripts that will be in essence code that the RDBMS runs. All you do is pass it the request and catch the reply back. You could ask for a row of data, a list of rows, multiple lists, or a count of some aspect and lastly a unique value. A second request would be the CUD parts of CRUD, we have just covered R for read. Create, update and delete functions are simple requests that will return a number back of how many rows were effected. For dealing with the schema you could write the scripts yourself or you could use the tool(s) that are part of the RDBMS or other 3rd party tools. That is all it is. Much like VFP with tables MySQL / DB2 / Oracle /...../ SQL Server will all tend to do the same thing(s). It is just a syntax issue :) Now SQL 2008 Express I am not sure if you get the user interface Sql Server Management Studio SSMS which is your Schema deffinition and maintenance tools. I thought that the Express version didn't give the GUI tools for that setup, just the engine that you can use. I could be wrong with the 2008 version??? -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
