Hello, I have a database that I have created using SQL Server Developer 2008.
I want to script it to a file so that it can be recreated by anyone at any time.
Any Ideas?
views:
78answers:
3
+1
A:
You can follow the steps at Pinal's site. Be careful to select all the options you want:
BobbyShaftoe
2009-05-06 23:52:18
Sometimes Sql Server 2008 doesn't script all objects if more than one category is selected: it's safer to do tables, then stored procedures, then views etc.
Stuart Dunkeld
2009-05-07 00:09:42
Do you have any source on this? Thanks.
BobbyShaftoe
2009-05-07 00:15:43
Just my own personal experience.. it certainly happened regularly, back when I was using scripts to move things around a lot.
Stuart Dunkeld
2009-05-07 02:01:38
+1
A:
To recreate the structure, right-click on the database and use Tasks --> Generate Scripts. Walk your way through the wizard, selecting those objects that you want to have created by your script. This TechNet article will serve as a good starting point for exploring how to do this if the process isn't obvious.
If you need both structure and data, you might want to consider using the Red Gate SQL Packager to script the data.
tvanfosson
2009-05-06 23:57:30
Microsoft should really have provided a comprehensive set of tools for that. That being said I do like Red Gate's products.
BobbyShaftoe
2009-05-07 00:05:44
@Stuart -- I looked through the wizard documentation briefly and didn't see that option. What step in the wizard is it? I'd like to update my answer.
tvanfosson
2009-05-07 00:15:19
It's in the "Choose Script Options" section, under "Table/View Options"
Stuart Dunkeld
2009-05-07 02:02:56
@Stuart - I don't see at MSDN (http://msdn.microsoft.com/en-us/library/ms186472.aspx) and I don't have access to a 2008 instance so I guess I'll leave the answer as stands with your comments to provide context.
tvanfosson
2009-05-07 02:35:10
A:
Try DBSourceTools.
http://dbsourcetools.codeplex.com
Its open source, and will script an entire database
- tables, views, procs and data to disk, and then allow you to re-create that database through a deployment target.
It's specifically designed to help developers get their databases under source code control.
blorkfish
2010-07-21 05:40:50