Thanks PS.

My intention is not for backing up the database, I am mainly playing with data( sometimes it also involves schema changes). I am trying to use back up as...

Thansk PS.

The reason for doing this:

1) We are initiate a new project and want to keep every configurable records changes we have done

2) we have a few group of poeple...

Thanks SSC

Yes, our processes are:

1) find the new update since last snapshot

2) create update scripts

3) once it get approved, apply to other server ( we have interface to perform this)

I...

Thanks all for the reply and advice

we have made a lots update during the week and I...

GSquared (9/11/2008)

---

For what you're doing, I would definitely look into either SSIS, or using a third party app like RedGate's Data Compare or ApexSQLS's Diff. Both of those apps...

Thanks GSquared.

You are right. May be I should make it clear at the first post.

Here is what I am trying to do:

We have a testing DB-1 which we are continuing...

bdba (9/7/2008)

---

If you are on SQL2005, then you can also use SSIS, which will make this task much easier and gain some performance too since it all happens in memory....

I am trying to copy data from one DB...

Thanks for the advice.

I forgot to mentioned that after I create the scripts, I'll also need to add 3 columns to each of these tables at the end.

I haven't use...