December 2, 2015 at 6:39 am
Not sure how to phrase this question for google so please bear with:
I have an access backend on a standalone. Want to migrate it to a SQL backend on my server. I want to create a front end accessible to all via sharepoint, with certain functionality, view records, update etc. 10 tables, only a little RI, not very complex overall.
We're talking small amounts of data, low concurrency.
I'm a DBA and new to application development but am happy to put in some time to learn.
It would be super nice if this would compliment my DBA skills.
What are my options for development? C#, phyton? Which is my best option.
Thank you!
December 2, 2015 at 7:41 am
snomadj (12/2/2015)
Not sure how to phrase this question for google so please bear with:I have an access backend on a standalone. Want to migrate it to a SQL backend on my server. I want to create a front end accessible to all via sharepoint, with certain functionality, view records, update etc. 10 tables, only a little RI, not very complex overall.
We're talking small amounts of data, low concurrency.
I'm a DBA and new to application development but am happy to put in some time to learn.
It would be super nice if this would compliment my DBA skills.
What are my options for development? C#, phyton? Which is my best option.
Thank you!
There is no correct answer here. I would build it in c# but that is because I am incredibly comfortable with that language. If I had to do it in python it would be like starting over. For somebody else it might be the exact opposite. If this is going to be available via sharepoint then perhaps doing it in c# would make sense since sharepoint is asp.net already. I have never developed anything for sharepoint though so not sure how integration with other languages works.
The other issue is that this site is dedicated to sql server and as such you are not too likely to get a lot of development assistance around here. There are some people though that can help depending on the language.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 2, 2015 at 9:36 am
Thanks Sean, appreciate the response. Understand what you're saying about dev help. Looking mostly for a starting point I guess. I'm principally a DBA but happy to branch out a little. I'll take a closer look at C# & python.
December 2, 2015 at 9:43 am
snomadj (12/2/2015)
Thanks Sean, appreciate the response. Understand what you're saying about dev help. Looking mostly for a starting point I guess. I'm principally a DBA but happy to branch out a little. I'll take a closer look at C# & python.
The problem really is that the starting point depends on your knowledge of these languages and we just have no way of knowing what that is. Since you want this available via sharepoint I would start with their documentation and see what they recommend for writing custom pieces.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply