CODEWITHSUNDEEP
sql-serversql-server-2008
Red Swan
Red Swan

Reputation: 15545

Take db script in sql server 2008 (only updates)

I want to generate the database script of sql server 2008. I want to generate only updates from particular date. how to do this?

Upvotes: 2

Views: 66

Answers (1)

Knubo
Knubo

Reputation: 8443

Your question is kind of unclear. Do you want to generate a database script that creates the tables or inserts data?

If it is data you can create selects that outputs what would be valid inserts:

create table test (a int, b int, c int);

select 'insert into test (a,b,c) values
    ('+convert(varchar, a)+','+convert(varchar, b)+','+convert(varchar, c)+');' 
    from test

On the select you could add a where clause where you only obtain data from a given date.

Edit: It looks like someone has discussed how to find changes between databases already on some other discussion forum. Have a look at:

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=27234

Upvotes: 2

Related Questions