Thanks - I might do that. And yep, we have RedGate and we use it for
comparing the differences between DBs, but I haven't used it to transfer
data yet. I'll see what I can find out. Thanks for the suggestions
everybody.
Cheyenne Throckmorton wrote:
You may also want to pose this question to the lists for atlantamdf.com
<http://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] <mailto:[EMAIL PROTECTED]>*
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
check out redgate.com <http://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]
<mailto:[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
<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/
<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 FusionLink <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
-------------------------------------------------------------