C# and Database Problem!

[isurutmv]

Mcn mama C# walin hadan yana system eke mata menna me tika karaganna oone

1.System eke database eka thiyenne VPS ekaka but mata oone internet nathi welawaka unath system ekan wada karanna puluwan wenna hadaganna saha offline wada karama ee data internet connect unama auto sync wenna

2. Database eke backup ekak sql file ekak widihata daily or weekly automatically customer ge email ekata send wenna oone

me tika karana widiha poddak kiyala dennako

 

[hichchiputha]

බුම්ප් හෙල්ප් තමය බ්‍රෝ

 

[isurutmv]

බුම්ප් හෙල්ප් තමය බ්‍රෝ

​

 

[dilduda]

can be done.. palleha links tika balapan..

https://stackoverflow.com/questions/18102002/build-an-asp-net-web-app-with-offline-functionality

https://stackoverflow.com/questions/14616764/sql-database-automatic-back-up

 

[sithija.h]

Mokakda bn DB engine eka? MS SQL or MySQL

MySQL wela nam dump commands use karala backup aragena yawanna puluwan,practically mama eh de karanawa bn, MS SQL nam script ekak liyala .BAK file export karaganna puluwan

 

[isurutmv]

can be done.. palleha links tika balapan..

https://stackoverflow.com/questions/18102002/build-an-asp-net-web-app-with-offline-functionality

https://stackoverflow.com/questions/14616764/sql-database-automatic-back-up

thanks mcn mama balannam rep++

 

[isurutmv]

Mokakda bn DB engine eka? MS SQL or MySQL

MySQL wela nam dump commands use karala backup aragena yawanna puluwan,practically mama eh de karanawa bn, MS SQL nam script ekak liyala .BAK file export karaganna puluwan

MySQL mcn

 

[sithija.h]

MySQL mcn

Ehenam patta easy bn, podi command ekak thiyenne eka liwwama script ekak create wenawa, eka unbata schedule ekakata email wenna haduwa nam hari, mama liwea C# Console application ekak,ekek db 4k daily backup wela email karanawa clientlata, mama unbata DB Backup karala command eka ewannam tikakin

 

[SriSoft]

use replication for auto sync. it will create an occasionally connected db system


run a script using a cron job or a scheduled task overnight to make a backup and email

 

[sithija.h]

Ehenam patta easy bn, podi command ekak thiyenne eka liwwama script ekak create wenawa, eka unbata schedule ekakata email wenna haduwa nam hari, mama liwea C# Console application ekak,ekek db 4k daily backup wela email karanawa clientlata, mama unbata DB Backup karala command eka ewannam tikakin

mysqldump -P 3306 -h serveraddress -u backup -ppassword --single-transaction dbname > folderpath\filename.sql


Onna oya RED color thiyana than welata server address, password, db name, filename, piliwelata denna mcn,



MySQL installation folder eke mysqldump kiyala EXE ekak athi, eke meh command eka gahuwath hari nathnam Command prompt welin eh file eka open karala meka gahuwath hari bn,

 

[rrkolla]

mannm owa dan na bump

 

[isurutmv]

mysqldump -P 3306 -h serveraddress -u backup -ppassword --single-transaction dbname > folderpath\filename.sql


Onna oya RED color thiyana than welata server address, password, db name, filename, piliwelata denna mcn,



MySQL installation folder eke mysqldump kiyala EXE ekak athi, eke meh command eka gahuwath hari nathnam Command prompt welin eh file eka open karala meka gahuwath hari bn,

meke email eka yanne nane bn

 

[chootyputha1]

 

[sithija.h]

meke email eka yanne nane bn

Email eka yawana eka wenama scene ekak neh bn


ekata Email library eka use karala, email eka authenticate karala, oya path eke create un file eka attach karala yawanna ona,
eka tikak loku code ekak bn, net eke ona tharam example athi,
barima unoth kiyapan mama ewannam source code eka

 

[isurutmv]

Email eka yawana eka wenama scene ekak neh bn


ekata Email library eka use karala, email eka authenticate karala, oya path eke create un file eka attach karala yawanna ona,
eka tikak loku code ekak bn, net eke ona tharam example athi,
barima unoth kiyapan mama ewannam source code eka

ela mcn mama try ekak deela baannam