You may also want to pose this question to the lists for atlantamdf.com the atlanta SQL Server user group. Last month their topic was on what you need to know as a developer upgrading from 2000 to 2005. I know you are going the opposite way, but there could be a good resource there.
Erics suggestion of redgate is also not a bad call, they have a lot of interesting useful tools. On 9/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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 > ------------------------------------------------------------- > > > > ------------------------------------------------------------- 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 -------------------------------------------------------------
