How to copy tables from a .mdf database

[kbutchm]

Hi,

I have designed an application in vb.net and using a .mdf database.
I'm worried if I change the database schema (add or alter tables), the data on the running app will be lost.
What I'm wondering is, if it is possible to copy database tables from one .mdf file to another?
Or is it possible to synchronize .mdf files?

Thanks in advance

 

[jmcilhinney]

If you want to alter the schema of an existing database then it's generally best to do so by running a SQL script. That way, all the existing data stays right where it is.