Regarding DTS

Hi,

I want to copy the data from Oracle table to excel file in DTS packages.
I have used transformation task, but it is asking for table but excel is a file.
please any body could tell em about this?

Thanks and Regards,
Purushotham,Use connection first.
In connection you will be able to find Excel files or Oracle.

Good Luck.

Regarding Bulk Copy in Transactional Replication..

Hi,
I got typical scenario in transacrtional replication. i want to avoid bulk
copy during replication.
Let me explain my scenario.
I’m doing transactional replication between two databases.
When publisher and subscriber created the data going to be bulk copied from
publisher table to subscriber table.
My main intension was to create replication between different tables with
different fields in which I got succeeded.
But main problem is I want to stop this bulk copy from publisher to
subscriber.
Scenario 1: my subscriber table may contain some previous data which will be
replaced with publisher data due to bulk copy.
I don’t want this .I want to avoid this bulk copy and wants to create
procedures(for insert, update and delete transactions) in subscriber which
will take care of replication.
I achieved almost everything but not able to avoid this bulk copy during
the creation of subscriber.
As I know the only way I can stop bulk copy is by creating subscription
without subscription agent. But here without subscription agent the
procedures(for insert, update and delete transactions)
won’t get created in subscriber.
Help me regarding the above scenario and I need it urgently.
Regards
Baji Prasad
I'm not entirely clear about your scenario, but it seems to me that you are
talking about nosync initialisations. Please have a look here and see if this
applies:
http://www.replicationanswers.com/NoSyncInitializations.asp
HTH,
Paul Ibison
|||hi paul..
im very thankfull for ur reply.
yes it helped me a lot atleast i got an idea how to avoid bulk copy.
again thanks man...
Regards
Baji Prasad
"Paul Ibison" wrote:

> I'm not entirely clear about your scenario, but it seems to me that you are
> talking about nosync initialisations. Please have a look here and see if this
> applies:
> http://www.replicationanswers.com/NoSyncInitializations.asp
> HTH,
> Paul Ibison
>
sql

Regarding Bulk Copy During Transactional Replication

Hi ,

I got a problem in regarding Transactional Replication.

Let me explain my scenario.

I’m doing transactional replication between two databases.

When publisher and subscriber created the data going to be bulk copied from publisher table to subscriber table.

My main intension was to create replication between different tables with different fields in which I got succeeded.

But main problem is I want to stop this bulk copy from publisher to subscriber.

Scenario 1: my subscriber table may contain some previous data which will be replaced with publisher data due to bulk copy.

I don’t want this .I want to avoid this bulk copy and wants to create procedures(for insert, update and delete transactions) in subscriber which will take care of replication.

I achieved almost everything but not able to avoid this bulk copy during the creation of subscriber.

As I know the only way I can stop bulk copy is by creating subscription without subscription agent. But here without subscription agent the procedures(for insert, update and delete transactions)

won’t get created in subscriber.

Help me regarding the above scenario and I need it urgently.

in sp_addsubscription, look at paramter @.sync_type, you can specify 'replication support only' and 'initialize with backup'. That allows you to skip the bcp. You can find more information about the latter here: http://msdn2.microsoft.com/de-de/library/ms147834(SQL.90).aspx.

Regarding Bulk Copy During Transactional Replication

Hi ,

I got a problem in regarding Transactional Replication.

Let me explain my scenario.

I’m doing transactional replication between two databases.

When publisher and subscriber created the data going to be bulk copied from publisher table to subscriber table.

My main intension was to create replication between different tables with different fields in which I got succeeded.

But main problem is I want to stop this bulk copy from publisher to subscriber.

Scenario 1: my subscriber table may contain some previous data which will be replaced with publisher data due to bulk copy.

I don’t want this .I want to avoid this bulk copy and wants to create procedures(for insert, update and delete transactions) in subscriber which will take care of replication.

I achieved almost everything but not able to avoid this bulk copy during the creation of subscriber.

As I know the only way I can stop bulk copy is by creating subscription without subscription agent. But here without subscription agent the procedures(for insert, update and delete transactions)

won’t get created in subscriber.

Help me regarding the above scenario and I need it urgently.

in sp_addsubscription, look at paramter @.sync_type, you can specify 'replication support only' and 'initialize with backup'. That allows you to skip the bcp. You can find more information about the latter here: http://msdn2.microsoft.com/de-de/library/ms147834(SQL.90).aspx.

Reg. Log Shipping.

I have configured a log shipping on one of my Database.
Both the two jobs i.e. copy log and resotre log jobs run successfully
on the destination machines without any problem but I dont see any
logs copied on the destination machine.
1.Initially I had a job which used to take the transaction log
backup ,I thought this might be the reason as all the transaction are
getting backed up log shipping copy job is not getting any transaction
log to copy to the destination server.
2.But after disabling the transaction log backup job also samething is
happening i.e. log shipping copy and restore job is running
successfully but i dont see anything copied or resotred.
I must be doing something wrong but dont know whats that..
Please help.
Thanks
Sudhir
Hi
Are you sure that job was running? Have you looked at view job history?
"Sudhir" <sam904@.gmail.com> wrote in message
news:1182320095.674384.196630@.u2g2000hsc.googlegro ups.com...
>I have configured a log shipping on one of my Database.
> Both the two jobs i.e. copy log and resotre log jobs run successfully
> on the destination machines without any problem but I dont see any
> logs copied on the destination machine.
> 1.Initially I had a job which used to take the transaction log
> backup ,I thought this might be the reason as all the transaction are
> getting backed up log shipping copy job is not getting any transaction
> log to copy to the destination server.
> 2.But after disabling the transaction log backup job also samething is
> happening i.e. log shipping copy and restore job is running
> successfully but i dont see anything copied or resotred.
> I must be doing something wrong but dont know whats that..
> Please help.
> Thanks
> Sudhir
>

Reg. Log Shipping.

I have configured a log shipping on one of my Database.
Both the two jobs i.e. copy log and resotre log jobs run successfully
on the destination machines without any problem but I dont see any
logs copied on the destination machine.
1.Initially I had a job which used to take the transaction log
backup ,I thought this might be the reason as all the transaction are
getting backed up log shipping copy job is not getting any transaction
log to copy to the destination server.
2.But after disabling the transaction log backup job also samething is
happening i.e. log shipping copy and restore job is running
successfully but i dont see anything copied or resotred.
I must be doing something wrong but dont know whats that..
Please help.
Thanks
SudhirHi
Are you sure that job was running? Have you looked at view job history?
"Sudhir" <sam904@.gmail.com> wrote in message
news:1182320095.674384.196630@.u2g2000hsc.googlegroups.com...
>I have configured a log shipping on one of my Database.
> Both the two jobs i.e. copy log and resotre log jobs run successfully
> on the destination machines without any problem but I dont see any
> logs copied on the destination machine.
> 1.Initially I had a job which used to take the transaction log
> backup ,I thought this might be the reason as all the transaction are
> getting backed up log shipping copy job is not getting any transaction
> log to copy to the destination server.
> 2.But after disabling the transaction log backup job also samething is
> happening i.e. log shipping copy and restore job is running
> successfully but i dont see anything copied or resotred.
> I must be doing something wrong but dont know whats that..
> Please help.
> Thanks
> Sudhir
>

Reg. Log Shipping.

I have configured a log shipping on one of my Database.
Both the two jobs i.e. copy log and resotre log jobs run successfully
on the destination machines without any problem but I dont see any
logs copied on the destination machine.
1.Initially I had a job which used to take the transaction log
backup ,I thought this might be the reason as all the transaction are
getting backed up log shipping copy job is not getting any transaction
log to copy to the destination server.
2.But after disabling the transaction log backup job also samething is
happening i.e. log shipping copy and restore job is running
successfully but i dont see anything copied or resotred.
I must be doing something wrong but dont know whats that..
Please help.
Thanks
SudhirHi
Are you sure that job was running? Have you looked at view job history?
"Sudhir" <sam904@.gmail.com> wrote in message
news:1182320095.674384.196630@.u2g2000hsc.googlegroups.com...
>I have configured a log shipping on one of my Database.
> Both the two jobs i.e. copy log and resotre log jobs run successfully
> on the destination machines without any problem but I dont see any
> logs copied on the destination machine.
> 1.Initially I had a job which used to take the transaction log
> backup ,I thought this might be the reason as all the transaction are
> getting backed up log shipping copy job is not getting any transaction
> log to copy to the destination server.
> 2.But after disabling the transaction log backup job also samething is
> happening i.e. log shipping copy and restore job is running
> successfully but i dont see anything copied or resotred.
> I must be doing something wrong but dont know whats that..
> Please help.
> Thanks
> Sudhir
>

Re-Extenting

I need to move (actually copy) some 2000 databases over
to a faster disk array. How can I do it so that the
databases get re-extented if you know what I mean? If I
do a regular Windows Explorer type copy, it will get
unfragmented on the o/s level, right? But how can I get
any unneeded extents out of there?
Yes the Windows copy of the file ( from sp_detach_db) will do new disk
allocation and (if the contiguous disk space is available), you'll get
pretty allocations.
To remove unused disk space
DBCC shrinkdb
or
DBCC shrinkfile
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:2dbe601c46a86$5defb910$a501280a@.phx.gbl...
> I need to move (actually copy) some 2000 databases over
> to a faster disk array. How can I do it so that the
> databases get re-extented if you know what I mean? If I
> do a regular Windows Explorer type copy, it will get
> unfragmented on the o/s level, right? But how can I get
> any unneeded extents out of there?

Re-Extenting

I need to move (actually copy) some 2000 databases over
to a faster disk array. How can I do it so that the
databases get re-extented if you know what I mean? If I
do a regular Windows Explorer type copy, it will get
unfragmented on the o/s level, right? But how can I get
any unneeded extents out of there?Yes the Windows copy of the file ( from sp_detach_db) will do new disk
allocation and (if the contiguous disk space is available), you'll get
pretty allocations.
To remove unused disk space
DBCC shrinkdb
or
DBCC shrinkfile
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:2dbe601c46a86$5defb910$a501280a@.phx
.gbl...
> I need to move (actually copy) some 2000 databases over
> to a faster disk array. How can I do it so that the
> databases get re-extented if you know what I mean? If I
> do a regular Windows Explorer type copy, it will get
> unfragmented on the o/s level, right? But how can I get
> any unneeded extents out of there?

Re-Extenting

I need to move (actually copy) some 2000 databases over
to a faster disk array. How can I do it so that the
databases get re-extented if you know what I mean? If I
do a regular Windows Explorer type copy, it will get
unfragmented on the o/s level, right? But how can I get
any unneeded extents out of there?Yes the Windows copy of the file ( from sp_detach_db) will do new disk
allocation and (if the contiguous disk space is available), you'll get
pretty allocations.
To remove unused disk space
DBCC shrinkdb
or
DBCC shrinkfile
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob" <anonymous@.discussions.microsoft.com> wrote in message
news:2dbe601c46a86$5defb910$a501280a@.phx.gbl...
> I need to move (actually copy) some 2000 databases over
> to a faster disk array. How can I do it so that the
> databases get re-extented if you know what I mean? If I
> do a regular Windows Explorer type copy, it will get
> unfragmented on the o/s level, right? But how can I get
> any unneeded extents out of there?