web services

I want to create a data synchronization feature between two database on the web service. Basically, I want asp.net webservice to get data from database1 and the data will be import into database2.

Both database1 and database2 is the same structure. Just different physical location.

Can you show me how to do that?

Thanks
LVL 1
ITsolutionWizardAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

apeterCommented:
Did you looked into this option ? "Database mirroring". More information in this link, http://msdn.microsoft.com/en-GB/library/ms151799.aspx
0
Dan McFaddenSystems EngineerCommented:
I would caution against using mirroring as Microsoft has issued a warning that mirroring will not be supported (removed) in future versions of SQL Server.  With SQL 2012 the recommendation is to use availability groups.

1. What OS?
2. What version of SQL Server (or other database engine)?
3. Will both instances of the database be writable?

Dan
0
ITsolutionWizardAuthor Commented:
It is Window Server 2008 R2, and Window SQL Server 2008.  I don't allow to configure the sql server. All I can do is to create stored procedures or SQL statement.
0
Dan McFaddenSystems EngineerCommented:
If you cannot manage the SQL server you will most likely have to work with your DBAs on this.

More questions:
1. What version of SQL 2008?  Express, Standard or Enterprise?
2. How fast must the data be synchronized?  What is the maximum delay between updates?
3. Is the database large or small (relatively)?
4. How frequently is the data updated or how often is the data changed/added?
5. Are there frequent schema changes?

Dan
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Services

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.