Is there a way to syncronize a database on a hosting server with the DB on my development machine so that changes I make to the DB with VS.NET show up in the database on the hosting server?

Thanks in advance for your replies.

Dan

Do you mean the changes as the Data changes or Structural changes?
What changes do you make to DB with VS.NET?

It is not advisable to have the changes made to development environment get sync with live environment. What happens if by mistake you made a change on development server that affects the entire system and that get replicated to the live server too.

Cheers!

_________________________
-Vijay G
Strive for Perfection

I meant things like adding stored procedures and tables as I build more and more functionality into the site.

Dan

Those are again structural changes. Having replication set up on both the DB servers, it can get sync with. But got to be careful in leaving anything incomplete on the development db, so that it doesn't affect the live one.

Cheers!

_________________________
-Vijay G
Strive for Perfection

happygv,

you can use replication to replicate STRUCTURAL changes?

Yes defiant,

With the help of MERGE replication. If I am not wrong.

Cheers!

_________________________
-Vijay G
Strive for Perfection