SQL SERVER - 2005 - Create Script to Copy Database Schema and All The

Why not join our community?, there are 5 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

18
kicks

kick it

SQL SERVER - 2005 - Create Script to Copy Database Schema and All The

published 1 year, 1 month ago, submitted by

pinaldave 1 year, 1 month ago

blog.sqlauthority.com — This is very simple but powerful. Explained with Images.

6 comments | category:

Database | Views: 54 | Get KickIt image code

tags: SqlServer2005, DBA, SQL, Database | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

pinaldave -

gavinjoyce -

mdopp - locrain -

sirrocco - mghaoui -

johnrummell - blisteringlunatic - monty - smallfox - RobChappel - ashithmr - jeremyh - senfo - rg443 - cdbh - rsivam - Samanta

Comments:

It would be nice if DotNetKicks had a way to dump rather than kick a post.

I'll leave the same comment here that I left on the blog:

Not to be overly critical but blogging on a wizard that is, for the most part, self-explanatory is somewhat akin to writing help file for Windows Notepad.

posted by nkoszyk 1 year, 1 month ago

Hear, hear to both your points

posted by topbanana 1 year, 1 month ago

I will leave the same comment I left on the blog:

Nick,

You are correct. However, If you search my blog how to do script complete database question is asked very often.

My blog is focused on helping users who need help and I think, looking at stats of this particular post, I am very satisfied.

Regards,
Pinal Dave (http://www.SQLAuthority.com)

posted by

pinaldave 1 year, 1 month ago

"It would be nice if DotNetKicks had a way to dump rather than kick a post."

If this was Digg I would Digg you down into infinity.

posted by motionblur 1 year, 1 month ago

I'm not sure that we have a big enough community to allow negative kicks. On the most active of days only about 10 stories make the homepage.

I don't kick posts that I don't like, I think this works well for now.

posted by

gavinjoyce 1 year, 1 month ago

You article shows how to create script to create the whole database from scratch. But in case if you don't need to create script for whole database, but script for changing database this method is impossible. Have you heard about Database Restyle - Library? This component allows the generation of script for database schemas synchronization:
http://www.perpetuumsoft.com/Product.aspx?lang=en&pid=55&tid=automaticsynchronization

posted by Samanta 6 months, 10 days ago