DTS

Hi friends,
In my project I have redesigned my database structure. In the existing
structure there is no Primary key and no relationship b/w data.
In the new structure Primary key and the relationship is added.
Now I want to migrate the existing data into the new structure.
There is a chance for duplicate records and also records that does not
satisfy referential integrity.
How to migrate the data? I want to have a copy of the duplicate records and
also the records which does not satisfy referential integrity.
Its a huge database, so i can't query table by table to find the mismatch
records.
How to proceed?
thanks
vanitha
thanks a lot
vanithaHi
I think a multi-phase data pump may be what you are looking for check out
http://www.sqldts.com/default.aspx?282
John
"Vanitha" wrote:

> Hi friends,
> In my project I have redesigned my database structure. In the existing
> structure there is no Primary key and no relationship b/w data.
> In the new structure Primary key and the relationship is added.
> Now I want to migrate the existing data into the new structure.
> There is a chance for duplicate records and also records that does not
> satisfy referential integrity.
> How to migrate the data? I want to have a copy of the duplicate records an
d
> also the records which does not satisfy referential integrity.
> Its a huge database, so i can't query table by table to find the mismatch
> records.
> How to proceed?
> thanks
> vanitha
> thanks a lot
> vanitha|||Thanks John.
I am not getting the Phases Tab. How we will get "Visual Basic
Transformation Script"
Thanks
vanitha
"John Bell" wrote:
> Hi
> I think a multi-phase data pump may be what you are looking for check out
> http://www.sqldts.com/default.aspx?282
> John
> "Vanitha" wrote:
>|||Hi
If you have enabled viewing multiphase transaformations (see figure 1.1)
then to get you will need to delete any existing transformations created and
then create new activeX transformation. You can add phases on the phases tab
on the transformation options, or the phases tab on the Active X
transformation properties (properties button on the general tab of the
transformation options dialogue)
John
"Vanitha" wrote:
> Thanks John.
> I am not getting the Phases Tab. How we will get "Visual Basic
> Transformation Script"
> Thanks
> vanitha
> "John Bell" wrote:
>

DTC question

Hi friends,
If I have a ms dtc log file on my hands, and it is, I believe, in some
binary format, is there any way to view it?
Thanks a lot in advanceHi,
> If I have a ms dtc log file on my hands, and it is, I believe, in some
> binary format, is there any way to view it?
I'm afraid there is no way to do it. The file is encrypted as an
internal part of DTC service.
Best regards,
Marcin Guzowski
http://guzowski.info|||It is sad.
It's actually dtc trace file.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:esu87d$p2a$1@.news.onet.pl...
> Hi,
>> If I have a ms dtc log file on my hands, and it is, I believe, in some
>> binary format, is there any way to view it?
> I'm afraid there is no way to do it. The file is encrypted as an internal
> part of DTC service.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

DTC question

Hi friends,
If I have a ms dtc log file on my hands, and it is, I believe, in some
binary format, is there any way to view it?
Thanks a lot in advance
It is sad.
It's actually dtc trace file.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:esu87d$p2a$1@.news.onet.pl...
> Hi,
>
> I'm afraid there is no way to do it. The file is encrypted as an internal
> part of DTC service.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

DTC question

Hi friends,
If I have a ms dtc log file on my hands, and it is, I believe, in some
binary format, is there any way to view it?
Thanks a lot in advanceHi,

> If I have a ms dtc log file on my hands, and it is, I believe, in some
> binary format, is there any way to view it?
I'm afraid there is no way to do it. The file is encrypted as an
internal part of DTC service.
Best regards,
Marcin Guzowski
http://guzowski.info|||It is sad.
It's actually dtc trace file.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:esu87d$p2a$1@.news.onet.pl...
> Hi,
>
> I'm afraid there is no way to do it. The file is encrypted as an internal
> part of DTC service.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
Falconer
Hi
"Falconer" wrote:

> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best links
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John
|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
FalconerHi
"Falconer" wrote:
> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best links
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>> Hi friends,
>> One simple and maybe silly question. Is DTC cluster resource a necessary
>> prerequisite for SQL Server to operate in cluster environment? If so,
>> why?
>> And it'd be great if anyone can direct me to any resource about DTC
>> internals. Not just setup & configuration but how it works on low level.
>> Thanks in advance.
>> Falconer
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John

DTC & SQL Server in cluster

Hi friends,
One simple and maybe silly question. Is DTC cluster resource a necessary
prerequisite for SQL Server to operate in cluster environment? If so, why?
And it'd be great if anyone can direct me to any resource about DTC
internals. Not just setup & configuration but how it works on low level.
Thanks in advance.
FalconerHi
"Falconer" wrote:

> Hi friends,
> One simple and maybe silly question. Is DTC cluster resource a necessary
> prerequisite for SQL Server to operate in cluster environment? If so, why?
> And it'd be great if anyone can direct me to any resource about DTC
> internals. Not just setup & configuration but how it works on low level.
> Thanks in advance.
> Falconer
If you are using distributed transactions on the virtual server you are
required to install a clustered resource.
http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best link
s
seem to be at
http://msdn2.microsoft.com/en-us/library/ms687102.aspx
John|||Thanks a lot John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5011A242-9AAD-4663-B1B5-2DF8EC6C5F84@.microsoft.com...
> Hi
> "Falconer" wrote:
>
> If you are using distributed transactions on the virtual server you are
> required to install a clustered resource.
> http://msdn2.microsoft.com/en-us/library/aa196691(SQL.80).aspx The best
> links
> seem to be at
> http://msdn2.microsoft.com/en-us/library/ms687102.aspx
> John