Did you consider dumping the database, moving the dump file to the new server and restoring it? That is the easiest way to do this. See: http://msdn2.microsoft.com/en-us/library/ms187315.aspx and http://msdn2.microsoft.com/en-us/library/ms186858.aspx for more information.
Sincerely, Brooks Wilson Never miss a good chance to shut up. - Will Rogers Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] Mike Staver <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/19/2007 04:43 PM Please respond to [email protected] To [email protected] cc Subject [ACFUG Discuss] Slightly OT: SQL Server Data transfer from version 2005 to 2000 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 ------------------------------------
<<image/gif>>
<<image/gif>>
<<image/gif>>
