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
-------------------------------------------------------------



Reply via email to