While developing an application I used EF automatic migrations. So now when I have deployed my app on VPS, I don't know how to add new tables and fields to my database.
Can I connect to the remote database directly from my project in VS2012, updating a connection string, and update the database using "update-database" in package manager console? Or do I need to install VS on my VPS and update the database from VPS?
My database is already filled with data, so I can't delete it and create again.
and you can specify your connection string name in above command :
Update-Database -ConnectionStringName "MyConnectionString"