|
|
Posted by xman on 06/12/07 01:56
On Jun 11, 5:28 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (cuneyt.baru...@illinois.gov) writes:
> > Thanks a lot for your answer Erland,
> > I was wondering about the tool you were using to accomplish the tasks
> > you mentioned. Can you tell me what it is called. and the names of
> > similar tools.
>
> It's an inhouse tool that I developed myself.
>
> As for commercial tools on the market, I don't have a very good overview
> what is available. But Microsoft offers "DataDude", that is Visual Studio
> Team Suite for Database Professionals. I believe the price tag is hefty.
>
> Many people use Red Gate'sSQLCompareto generate their change scripts.
>
> There is something called SQLFarms, which looks interesting, but I have
> looked very very little on it.
>
> > Can you also tell me how long typically takes for you
> > to administer this type of change.
>
> There are two steps: 1) Implement the change script. 2) Running it.
> Implementing the change script takes quite some time. But I usually
> implement a whole bunch of changes at a time. Our system is a product,
> which runs at some 20 customer sites, and beside the productiondatabases
> there is an unknown number of testdatabases. How long time it takes
> running the change script depends on the size of the data base. We are
> lucky in that our customers are not 24/7 shops, but if a script needs
> to run for 24 hours, this is permissible. Again, keep in mind that a
> script includes several table changes. Typically I would not accept two
> hours to reload 2.8 million rows.
>
> --
> Erland Sommarskog,SQLServerMVP, esq...@sommarskog.se
>
> Books Online forSQLServer2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online forSQLServer2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Hi there,
you may want to check out our xSQL Object (http://
www.xsqlsoftware.com) for generating those change scripts - we have a
free lite edition available also.
Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com
Navigation:
[Reply to this message]
|