By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,688 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

Database Replication to online Hosting -P

mohamednor
P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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