Invoking MigrationWizardConsole

I have a couple of questions concerning invoking the application MigrationWizardConsole.exe. Can this application be invoked directly or is invoked from the GUI app, MigrationWizard.exe? My other question is if the MigrationWizardConsole can be invoked directly what are the parameters?

Thanks

Ron Cotton

MigrationWizardConsole is used only by setup during upgrades. It should not be invoked by users.|||

Sasha,

Thanks for the information...Do you have any suggestions concerning automating the migration of SQL 2000 databases to SQL 2005?

Thanks

Ron C

Interview Questions Feb 24, 2006

What is Native Image Generator (Ngen.exe)?
The Native Image Generator utility (Ngen.exe) allows you to run the JIT
compiler on your assembly's MSIL and generate native machine code which
is cached to disk. After the image is created .NET runtime will use the
image to run the code rather than from the hard disk. Running Ngen.exe
on an assembly potentially allows the assembly to load and execute
faster, because it restores code and data structures from the native
image cache rather than generating them dynamically.Native images load
faster than MSIL because JIT compilation and type-safety verification
is eliminated.
Full Interview Questions for .NET and SQL Server
http://www.geocities.com/dotnetinterviews/
Help the community to make job search easier mail your questions to
jobatyourdoorstep@.yahoo.co.in
Looking for a onsite job mail your resumes at
jobatyourdoorstep@.yahoo.co.inShiprasad Koirala|||"Jobs" <jobatyourdoorstep@.yahoo.co.in> schrieb:
> The Native Image Generator utility (Ngen.exe) allows you to run the JIT
> compiler on your assembly's MSIL and generate native machine code which
> is cached to disk. After the image is created .NET runtime will use the
> image to run the code rather than from the hard disk.
There's a little contradiction in the two sentences above. The native image
is stored in a special area of the GAC on the disk (typically harddisk).
BTW: In general Microsoft's public newsgroups are a place for peer support
and not an advertising platform.
--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Interview Questions Feb 24, 2006

What is Native Image Generator (Ngen.exe)?
The Native Image Generator utility (Ngen.exe) allows you to run the JIT
compiler on your assembly's MSIL and generate native machine code which
is cached to disk. After the image is created .NET runtime will use the
image to run the code rather than from the hard disk. Running Ngen.exe
on an assembly potentially allows the assembly to load and execute
faster, because it restores code and data structures from the native
image cache rather than generating them dynamically.Native images load
faster than MSIL because JIT compilation and type-safety verification
is eliminated.
Full Interview Questions for .NET and SQL Server
http://www.geocities.com/dotnetinterviews/
Help the community to make job search easier mail your questions to
jobatyourdoorstep@.yahoo.co.in
Looking for a onsite job mail your resumes at
jobatyourdoorstep@.yahoo.co.inShiprasad Koirala|||"Jobs" <jobatyourdoorstep@.yahoo.co.in> schrieb:
> The Native Image Generator utility (Ngen.exe) allows you to run the JIT
> compiler on your assembly's MSIL and generate native machine code which
> is cached to disk. After the image is created .NET runtime will use the
> image to run the code rather than from the hard disk.
There's a little contradiction in the two sentences above. The native image
is stored in a special area of the GAC on the disk (typically harddisk).
BTW: In general Microsoft's public newsgroups are a place for peer support
and not an advertising platform.
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Interview Questions Feb 24, 2006

What is Native Image Generator (Ngen.exe)?
The Native Image Generator utility (Ngen.exe) allows you to run the JIT
compiler on your assembly's MSIL and generate native machine code which
is cached to disk. After the image is created .NET runtime will use the
image to run the code rather than from the hard disk. Running Ngen.exe
on an assembly potentially allows the assembly to load and execute
faster, because it restores code and data structures from the native
image cache rather than generating them dynamically.Native images load
faster than MSIL because JIT compilation and type-safety verification
is eliminated.
Full Interview Questions for .NET and SQL Server
http://www.geocities.com/dotnetinterviews/
Help the community to make job search easier mail your questions to
jobatyourdoorstep@.yahoo.co.in
Looking for a onsite job mail your resumes at
jobatyourdoorstep@.yahoo.co.in
Shiprasad Koirala
|||"Jobs" <jobatyourdoorstep@.yahoo.co.in> schrieb:
> The Native Image Generator utility (Ngen.exe) allows you to run the JIT
> compiler on your assembly's MSIL and generate native machine code which
> is cached to disk. After the image is created .NET runtime will use the
> image to run the code rather than from the hard disk.
There's a little contradiction in the two sentences above. The native image
is stored in a special area of the GAC on the disk (typically harddisk).
BTW: In general Microsoft's public newsgroups are a place for peer support
and not an advertising platform.
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Interop.SQLMERGXLib.dll

How did you use regsvr? I think something like this
should work:
regsvr32.exe "c:\program files\microsoft sql server\80
\com\sqlmergx.dll"
This article can be used for some general help, but it
looks like you have the correct references:
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;319646
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
indeed I've already read the article, but I've still the problem. The
command that I've launch is:
regsvr32.exe {mypath}\Interop.SQLMERGXLib.dll
and I obtain the following error:
... .dll was loaded, but the DllRegistreServer entry point was not found.
This file can not be registered.
I've looked also for sqlmergx.dll but I haven't found it on my PC... where
should I find it? Is it available in Internet? Do you think it will solve my
problem?
Thanks again
"Paul Ibison" wrote:

> How did you use regsvr? I think something like this
> should work:
> regsvr32.exe "c:\program files\microsoft sql server\80
> \com\sqlmergx.dll"
> This article can be used for some general help, but it
> looks like you have the correct references:
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;319646
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Hi Paul,
I didn't find sqlmergx.dll in the path that you have written, so I've copied
one from another SQL Server installation and then registered it with
regsrvr32: the registration succeded but when I launch my procedure I obtain
the following error:
... Check to see if the component is registered correctly
although the registration is correct.
I precise that I have already done all your suggestion that you have
explained.
Can you still help me? I precise also that on my computer I've installed
only MSDE and not all SQL Server...
"Paul Ibison" wrote:

> It should be in c:\program files\microsoft sql server\80
> \com\
> However it is not prefixed with Interop.
> Inside the Visual C# .NET project, you add a reference to
> the Microsoft SQL Merge Control 8.0 COM object, and then
> add the following code:
> using System;
> using System.Runtime.InteropServices;
> using SQLMERGXLib;
> As far as I recall, adding the reference imports the type
> library, so assuming the COM object is registered (it
> should be from the SQL Installation) there's no need to
> use regsvr32.exe
> HTH,
> Paul Ibison
>
|||Siu,
sorry about this but I can't do much more. I don't have
VS installed in my current position. Some others here
might take up the thread, but if not I would suggest that
you post this in a C# group, as it is more of a COM
interoperability problem.
HTH,
Paul Ibison
|||thank you anyway.
I appreciated very much your help
"Paul Ibison" wrote:

> Siu,
> sorry about this but I can't do much more. I don't have
> VS installed in my current position. Some others here
> might take up the thread, but if not I would suggest that
> you post this in a C# group, as it is more of a COM
> interoperability problem.
> HTH,
> Paul Ibison
>