Tuesday, February 14, 2012

Database upload

I want to upload my DB created with WebMatrix to an external SQL-server. Is that possible with MSDE or WebMatrix??To upload your database you have to do the following things:

1st. Create the database on the destination sql server (you can create an sql script for that, if you have Enterprise Manager)

2nd. Either use a custom SQL script or Enterprise Manager to upload your data.

Enterprise manager comes with SQL Server, not with MSDE.|||You can also use DTS, since MSDE includes the command-line tool.

Don