Segregating data and schema script

Question

Segregating data and schema script

Poonam Arora

Valued Member

Points: 66
More actions
August 11, 2004 at 7:58 am

#108778

I need to know how does one go about taking the data backup(exclusively)...Can we generate some script(Insert in tables)? Any tool to achieve the same ?

The backup does give u the whole stuff(data + schema).But the following is what we plan to achieve....
a) take the schema script and create the database.
b) take the data backup(how u do that ...have to find) and restore it in ur new database.

Let me share with u a typical scenario :::

a team member has created lots of data with the prev version of the database.But since schema has changed he has to go about recreating the database at the same time restoring the already created massive records he had in the previous database (or may run a script which has all the inserts 4 all tables --This is what i am looking for !)

Regards
Poonam

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

I'm not sure I understand your question, but if you want to copy tables schema and data from one database to another database, you can use DTS.

Greg

mark baekdal-145375 SSCrazy Points: 2200 More actions · Answer 2

check out http://www.dbghost.com which gives out a free schema and data scripting tool as part of the evaluation of the product.

Nilesh Leuva SSC Veteran Points: 201 More actions · Answer 3

Poonam,

Step 1:

Right Click your database in SQL Server Enter. Manager and select the option "All Tasks". You will find here different options that can help you. Specifically, "Import/Export Data" and "Back Up Data"

Step 2:

In your EM, expand the Server that you are working with. Expand the "Managemnet" node and select Backup. Right click the "BackUP" option and create a new back up. You can set it to recurrances as per your choice. You don't need to right scripts for reoccurances.

Hope I replied your answers.

Thanks and Take Care.

Nilesh

Thomas-142793 SSC Enthusiast Points: 151 More actions · Answer 4

Try http://www.sqlscripter.com for data scripting.

- Thomas