Re: Data Migration

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

There isn't anything that I know of that will do all of that automatically.
The tool package from www.red-gate.com has a tool to compare the schema and
one to compare data. I know the schema tool will generate change scripts
but I don't know if it can generate data change scripts. That's usually
highly dependant on the schema and business rules.

--
Andrew J. Kelly SQL MVP


"Michael @ SGMS" <MichaelSGMS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:82853B5B-571D-4F94-A967-CC0DD2BBA510@xxxxxxxxxxxxxxxx
> My first thought was to use a linked server (where the data I want to
> migrate
> is) and then so something like:
>
> Insert into newdb..TableA
> Select * from olddb..TableA
>
> BUT, there are contraints on the new database that cause these to fail. I
> was hoping there was something out there that would script the dropping on
> the indexes and keys on the new db, then the data move, then the creation
> of
> the keys and constraints on the new db.
>
> I already have a script that will make the old server structure like the
> new....
>
> "David Gugick" wrote:
>
>> Michael @ SGMS wrote:
>> > This does not help. This only, unless I missed it, will give me the
>> > difference in structure.......What about moving the data?
>> >
>>
>> Couldn't you script these changes using T-SQL and modify as needed per
>> client? Another option is to use DTS.
>>
>> --
>> David Gugick
>> Quest Software
>> www.imceda.com
>> www.quest.com
>>
>>


.

Relevant Pages

  • Re: Data Migration
    ... DB Ghost will do data and schema in a single process. ... management for SQL Server ... > one to compare data. ... > but I don't know if it can generate data change scripts. ...
    (microsoft.public.sqlserver.tools)
  • Re: WSH in VS.NET 2003?
    ... or will wsh xml include a ... Get the "TechNet Script Center Sample Scripts" ... Other|Useful Scripting Technologies|Saving Data in XML Format ... There is no schema for getting MS. ...
    (microsoft.public.scripting.wsh)
  • Re: Synchronization Wizard weirdness
    ... Using the Oracle Enterprise Manager and Oracle Change Manager packages, ... :> I have a Test Schema in the same database as the Main schema and need to ... Wizard between the Main schema and Test schema -- obviously returned the full ... :> All seems to go well, until the script actually runs. ...
    (comp.databases.oracle.tools)
  • Re: Freeware 32bit command line hardware detector?
    ... for the purpose of creating a hardware independent Windows XP Ghost ... or whatever I could compare against) and then the ... script would know which HAL to copy into windows\system32 and then the ...
    (microsoft.public.windowsxp.general)
  • Re: Perl script to mimic uniq
    ... > That is not what Unix uniq does. ... Can I se this script to compare the n columns of a file, ... > I suspect there's more to your original problem than you are telling ...
    (comp.lang.perl)