473,387 Members | 1,844 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Database Replication to online Hosting -P

mohamednor
Hi all - thank you in advance
I want your suggestion in this case

I have develped a data driven system using windows application (winforms) and SQL Server 2008 R2

now i use the system in local sql server (sql Server)

recently Some one asked me if its possible to access the database online (for reports only) so to get that i have Registered a hosting plan in winhost ; my main objective was to create the same database in the online hosting and then Use MS SQL server's replication feature to update changes in the local server to the online version of my database so i can access the online version using the net and get reports from it;
but finnaly i realized that this is not possible becouse in the online database i have no access to the SQL Server's SA user that is required to perform replication.

So I am asking you :

1. If it is possible to proceed in that way ( Replication to the online database) if yes HOW I CAN DO?

2. if that is not possible what are the other ways i can achieve these ( Access my database from enternet )

3. Also i was thinking about an other idea that is to write a program that automatically takes backup from the local server's database and then restores to the online database !! What about this idea -Not Tested Yet- ?
Apr 9 '16 #1
0 1348

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Colin Mangiagalli | last post by:
Hi I was just wondering if someone could tell me if postgresql supports some kind of database replication or mirroring and if so, how easy is it to set up. Thanks Colin
0
by: Michael Wimmer | last post by:
Hi, I need some advice on database replication. A customer wants his databases replicated between two servers, connected by the internet. The database structure will be quite simple, mainly...
1
by: Andrew Chanter | last post by:
I developed 3 different replicated database applications in MS Access for 3 different corporate clients in Access 97 several years ago to enable data to be shared across wide area networks. I...
1
rcollins
by: rcollins | last post by:
I am using access 2003 on xp machines, databases stored on the main server. Wehave different locations, and accessing databases is pretty much no there from the other locations due to distance and...
30
by: iheartvba | last post by:
Hi, I already have 3 Databases running: A. they all have the same tables and the same structure B. There is no 1 Master table they are all separate tables What I want to do is to merge them...
2
ram09
by: ram09 | last post by:
i want to make a master server and a slave for my database ...do anyone have an idea on how i can setup a database replication on two different servers please???thanks^^
1
by: Deborah Goshen | last post by:
I would like to enable my database users to replicate their Access database without going through the full steps all the time. Is there a way to create a command button that carries out the database...
0
by: natahen | last post by:
Hi everyone, I carry out university research and at the moment I am working on a technology of diverse database replication. I believe the solution is going to change the world of data reliability...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.