Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can use Visual Database Tools to work with Scripts. You can generate Change and Create scripts from within Table Designer; create scripts for SQL, stored procedures, triggers, tables, and views from Solution Explorer; or you can run scripts you create yourself.
When you create a script using Visual Studio 2005 it will have the extension .sql, but if you have scripts with the following extensions, you can still use them:
.tabTable definition
.prcStored procedure
.viwView
.trgTrigger
.bndColumn bindings
.defDefaults
.rulRules
.udtUser-defined data types
.idnIdentity
.drnDeclarative referential integrity
.fkyForeign key constraints
.prvPermissions
.logLogins
.usrUsers
.grpGroups
In This Section
How to: Run SQL Scripts in Solution Explorer
How to: Generate Change Scripts
How to: Generate Create Scripts
How to: Run a Script on a Database Other than the Current Default
Reference
Reference (Visual Database Tools)