Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Question About online data


Question About online data

Author
Message
khurram sultan
khurram sultan
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 65
front end = VB.net desktop app frame work 4.0
language = VB
database = sql 2012 (express edition) for client end
Its not web-front end its client based (windows form application)
I wana give full functionality from my Client software (Insert , update , delete, select etc)just like Tally
I am not planning to give web functionality at this time .
even if i do i will use web front end just for reports not insert or updates from web portal

May be i cant explain my self so i am giving an example

suppose i have a customer having 5 branches and every branch has 5 computers all working on my erp system
every branch has 1 database server and 4 database clients

i wana connect all branch database servers so that all branch servers have same database

now lets say i have 200,000 customers all with branches and all with branch servers how will i connect all those databases

every customers database has nothing to do with others customers database


i am developing and ERP system i already have more than 1k clients at the moment

i am planning to expand my erp system

but i need online solution in my software

so that my clients can input data from any where just like quick book or tally

i just want any information regarding this topic

whether should i use replication and what would be the complications

Another question which i wanted to ask should i make different databases for each client and use replication or single database for temporary data point and then rerouting it to other clients


or just live connection

or any thing else

thanks
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2879 Visits: 2235
Information is not sufficient to provide any conclusion. You need to have web based front end to input data. What about the backend? How is your database design? How users do entry to database?

If replication what kind of replication model fit to your requirement?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
khurram sultan
khurram sultan
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 65
sorry for incomplete data
front end = vb.net
database = sql 2012 (express edition) for client end

need to connect my desktop application so that it can input data online
LutzM
LutzM
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 7001 Visits: 13559
Still not enough information.
Did you use vb.Net to develop a Web-Frontend or is it a client based solution?
What online functionality will you provide (full functionality or just part of it)?
Do you have a detailed and profound security concept to separate the different customers as well as protect the data from any kind of intrusion/manipulation?
Be aware that allowing external access to an ERP system usually is not a recommended scenario...

I strongly recommend to separate the Web functionality from the original ERP system. Not only in a separate database on the same server but on a separate server. Harden the connection between the two as much as possible. Transfer the data to the ERP system using "bullet proof" stored procedures. Be suer you know how to eliminate the risk of SQL injection.

Always keep in mind: As soon as there's a Web site to get acces o your system, you no longer have only the customers you know of but also a ton of people interested in getting the information you stored...



Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
khurram sultan
khurram sultan
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 65
Did you use vb.Net to develop a Web-Frontend or is it a client based solution?

Its not web-front end its client based (windows form application)

What online functionality will you provide (full functionality or just part of it)?

i wana give full functionality just like Tally

Do you have a detailed and profound security concept to separate the different customers as well as protect the data from any kind of intrusion/manipulation?

Thats another question which i wanted to ask should i make different databases for each client and use replication or single database for temporary data point and then rerouting it to other clients


Be aware that allowing external access to an ERP system usually is not a recommended scenario...
some of ERP systems are already doing it

I strongly recommend to separate the Web functionality from the original ERP system. Not only in a separate database on the same server but on a separate server. Harden the connection between the two as much as possible. Transfer the data to the ERP system using "bullet proof" stored procedures. Be suer you know how to eliminate the risk of SQL injection.

I am not planning to give web functionality at this time .

even if i do i will use web front end just for reports not insert or updates from web portal
And i am well aware of sql injection


Thanks
LutzM
LutzM
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 7001 Visits: 13559
If it's client based, how do you plan to expand your software
so that my clients can input data from any where
?

That's contradictory to your client based installation.

At this point I step back. To me "Tally" means a numbers table and I don't think I'll spend the time of a product research to figure out what you might be looking for.

As a side note: Just the phrase "some of ERP systems are already doing it" doesn't make this concept more recommendable...



Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
khurram sultan
khurram sultan
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 65
Thanks litz for ur time

may be i am unable to explain my self so i have updated my question with an example. Please check it
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16542 Visits: 16997
Honestly I think you should hire a consultant to help you design your system. There are items in your list that contradict each other and many that sound as though you are unfamiliar with the technology and how these things work.

Maybe webservices would be a help here?? hard to say based on the very limited details in your posts.

_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search