Monday, February 20, 2012

Microsoft SQL Server Management Express...help

Hi,

im trying to learn SQL Server Management Express

know a good place to start?

Im trying to upload an sql database from Visual Web Developer

Ive been told that this can be done using SQL Server manegement express...

cant see how to import into it yet... any ideas?

With Express you won't be able to upload it directly. What you'll have to do is script the database, then run the script on the production server. This will not keep the data around though. "Script Database as Create to", when you right click on the database. The "real" version of the tool (as opposed to Express) has more features.

If you want to deploy a database, try this (I haven't tried it, but it looks promising)

http://forums.asp.net/thread/1431636.aspx

|||Hi~ What do you mean by 'Upload", if you need the data, you can attach the database files (.mdf and .ldf) in Management Studio. Open it -> Right click on 'Databases' -> Attach...

No comments:

Post a Comment