Technique to convert database to sql script?

Question

I want to convert a database into an sql script so that i can recreate it elsewhere. I want the copy to be same as original.

How do i do that ?

Sachin · Accepted Answer · 2013-05-15 12:10:32Z

6

You can generate DB Script using Management Studio through available option.

Right Click on Database -> Task -> Generate Scripts

enter image description here

Here is an option for including Data with Schema in script

edited May 15, 2013 at 12:10

answered May 3, 2013 at 22:51

Sachin

41.1k7 gold badges94 silver badges107 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

gregnorm Over a year ago

The database is copied, but with some errors. I am ignoring the errors for now. Main thing is There are no rows in any of the tables !!! How do i get the rows also in my script, ie insert into....?

Sachin Over a year ago

There is an option 'Advanced' on Set Scripting option screen. Click on that and check Type of Data to script, select its value to Schema and Data. then it will also include the data.

Arsen Over a year ago

Also, if you want to simply get the exact same database somewhere else, you may want to do a backup to disk, copy the file, and restore it on the other server. This way it will take with it everything (data schema, etc.)

gregnorm Over a year ago

@Sachin - Type of Data to script option is not present. Probably, disabled by admin???

gregnorm Over a year ago

@Arsen - tried that. but db is on remote server. I can rdp into remote server, but cant copy paste backup into local. I was hoping to copy to local and then upload that copy to another server. Well i guess thats not gonna happen.

|

Arsen · Accepted Answer · 2013-05-03 22:50:37Z

1

In SQL Management Studio, right click on the database, select Tasks->Generate Scripts. It will guide you through a wizard.

answered May 3, 2013 at 22:50

Arsen

9658 silver badges7 bronze badges

1 Comment

gregnorm Over a year ago

The database is copied, but with some errors. I am ignoring the errors for now. Main thing is There are no rows in any of the tables !!! How do i get the rows also in my script, ie insert into....?

Collectives™ on Stack Overflow

Technique to convert database to sql script?

2 Answers 2

7 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related