We are thinking of restructuring our database development and deployment processes by using DBGhost, we want to move away from the central development database and bring the database to the source control.
One of the problems we have is a big table with static data (containing translated language strings), it has close to 200K rows.
I know that our best solution is to move these stings into resource files, but until we implement that, will DbGhost be able to maintain all this static data and generate our development and deployment databases in a short time? And if not is there a good alternative to filling up this table whenever we need to?
Would you be able to take a look at SQL Source Control? We've just added static data support and are looking for feedback prior to the full release.
http://www.red-gate.com/MessageBoard/viewtopic.php?t=12298
Would you be able to explain why you're moving away from a central database development model?