How can i replicate in mi bd server from .NET using LINQ?

Question

I have a data model on LINQ in my project wich i generated from a DB on SQL Server the problem is that all the changes that i make only have effect in the Local DB on my project but not in the web SQL server, how can i replicate the changes automatically?

Answer 1

To sync your schema you have to use a tool like Visual studio 2010 database projects

http://msmvps.com/blogs/deborahk/archive/2010/05/02/vs-2010-database-project-an-introduction.aspx

or

http://www.red-gate.com/products/SQL_Compare/index.htm

Or you have to manually do it.