Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kpgraci
Yak Posting Veteran
68 Posts |
 Posted - 2010-12-16 : 16:35:45
|
| I have a sql server 2008 dbf file (ver 655) I created in visual studio 2010 that I need to convert to a sql server 2005 (ver 611) format. Now I know there is no downgrade path, but this is an empty database - so all I really need is the tables and stored procedures.Knowing nothing much about sql server, I would like to extract, print, copy/paste, whatever, the stored procedures and then somehow put them in the new 2005 database.I've only ever used visual studio's server explorer to manage the database files, and by the way, these are sql server express user instance databases.There's only about 50 or so stored procedures, so worst case I could copy the text to notepad and paste in the new db - is there a more automated way to do this?kpg |
|
|
the_amol
Starting Member
6 Posts |
Posted - 2010-12-17 : 02:56:52
|
| well ofcourse there is a way..u can use the Script database to a file/query.Steps:1) Right click on your database2) Go to Tasks>Generate Scripts3) Follow the wizard to select the objects whose script you want to generate. u can generate scripts for creation of database, table, stored procedures, values etc.4) save the file as sql.5) Run the saved file in your new database and well everything will be there.Thanks & RegardsAmol Vermahttp://cybertechhawks.wordpress.com |
 |
|
|
kpgraci
Yak Posting Veteran
68 Posts |
Posted - 2010-12-17 : 09:39:55
|
| Fabulous! You have made my year.kpg |
|
|
|
|
|
|
Extracting stored procedures