Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question About online data Expand / Collapse
Author
Message
Posted Monday, April 21, 2014 2:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 21, 2014 12:03 PM
Points: 15, Visits: 58
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
Post #1563403
Posted Monday, April 21, 2014 2:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #1563407
Posted Monday, April 21, 2014 2:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 21, 2014 12:03 PM
Points: 15, Visits: 58
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


Post #1563408
Posted Monday, April 21, 2014 3:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 7,042, Visits: 12,971
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
Post #1563412
Posted Monday, April 21, 2014 10:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 21, 2014 12:03 PM
Points: 15, Visits: 58
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
Post #1563547
Posted Monday, April 21, 2014 11:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:43 AM
Points: 7,042, Visits: 12,971
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
Post #1563560
Posted Monday, April 21, 2014 11:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 21, 2014 12:03 PM
Points: 15, Visits: 58
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
Post #1563568
Posted Monday, April 21, 2014 12:00 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 13,138, Visits: 11,977
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)
Post #1563575
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse