way to do SQL export from MDF>

[masfenix]

hey is there a way to "export" data/table/schema in a .sql file from a mdf file I use?

[jmcilhinney]

You would most likely do that from SQL Server Management Studio, not a VB.NET app.

[masfenix]

Hey thanks for the reply. I guess there isnt a way because i couldnt even find is uing LIVE search. (mind you i havnt googled ityet).

I just want to give the option to my users to transfer the database over to a full blown server 2005 or setup a online database and change the connection string.

[jmcilhinney]

I take it that you are deploying your app for SQL Server Express with an MDF file, correct? If so then anyone who is using SQL Server can simply attach the MDF to the server in Management Studio. Each SQL Server database IS an MDF file already. They are just permanently attached instead of attached and detached on demand as they can be with SQL Server Express.

[szlamany]

You can also use the T-SQL BACKUP and RESTORE commands to move a database from one server to another.