check out redgate.com they have 2 products we use. sql compare for schema and sql data compare for data.
jonese On 9/19/07, Mike Staver <[EMAIL PROTECTED]> wrote: > I have two databases with identical schemas for all the tables, stored > procs, functions, etc. The DB in SQL 2000 is blank. I need to transfer > all the data from the 2005 version into it, keeping identity values for > the ID columns. I have approximately 800 tables - so doing this > manually just isn't an option today. Does anybody know of a nice > utility to do this sort of thing? > > > ------------------------------------------------------------- > Annual Sponsor FigLeaf Software - http://www.figleaf.com > > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > > ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
