Newbie Question on DTS Object Trasnfer

Very new to SQL Server. Was asked to copy some tables from a Prod to a
Test database in the same instance. (This system is not yet in
production.)

I used the Microsoft course book guidance for course 2072 A, the lab
exercise in Module 9, page 33 to give me some guidance. In the exercise
they were copying tables as well as views.

While in the wizard the guidance said to uncheck 'copy primary and
foreign keys' and uncheck 'copy full text indexes'.

While I realize that might be because of the nature of copying views, I
used that guidance to copy the tables. Is this correct or should I do
it over and copy both the keys and full text indexes?

I DID copy base indexes.

Thanks in advance.

GerryDataPro (datapro01@.yahoo.com) writes:

Quote:

Originally Posted by

Very new to SQL Server. Was asked to copy some tables from a Prod to a
Test database in the same instance. (This system is not yet in
production.)
>
I used the Microsoft course book guidance for course 2072 A, the lab
exercise in Module 9, page 33 to give me some guidance. In the exercise
they were copying tables as well as views.
>
While in the wizard the guidance said to uncheck 'copy primary and
foreign keys' and uncheck 'copy full text indexes'.
>
While I realize that might be because of the nature of copying views, I
used that guidance to copy the tables. Is this correct or should I do
it over and copy both the keys and full text indexes?

You should certainly copy the keys. I don't use full-text, so I don't know
if there is any good reason why they are not copied by default. Then
again, with a little luck your database does have full-text indexes.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks...ran a few tests looking at the dll before and after trying
different options and kept the keys. Worked out fine...makes you wonder
why Microsoft would use an example of a dts move in its book for
newbies that would only confuse the issue.

Erland Sommarskog wrote:

Quote:

Originally Posted by

DataPro (datapro01@.yahoo.com) writes:

Quote:

Originally Posted by

Very new to SQL Server. Was asked to copy some tables from a Prod to a
Test database in the same instance. (This system is not yet in
production.)

I used the Microsoft course book guidance for course 2072 A, the lab
exercise in Module 9, page 33 to give me some guidance. In the exercise
they were copying tables as well as views.

While in the wizard the guidance said to uncheck 'copy primary and
foreign keys' and uncheck 'copy full text indexes'.

While I realize that might be because of the nature of copying views, I
used that guidance to copy the tables. Is this correct or should I do
it over and copy both the keys and full text indexes?

>
You should certainly copy the keys. I don't use full-text, so I don't know
if there is any good reason why they are not copied by default. Then
again, with a little luck your database does have full-text indexes.
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Newbie MSDTC question

What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster?
Cluster is already setup and virtual sql instance running ok...
Thanks
MSDTC or the Microsoft Distributed Transaction Cordinator is used for
distributed transactions.
A good description of it can be found in SQL Server Books Online:
http://msdn.microsoft.com/library/de...ar_cs_321x.asp
As you can see in the following article; MS DTC is not required for the
clustered SQL Server to work:
http://support.microsoft.com/default...b;en-us;260758
However if you have it installed on your server you need to run it in a
clustered state as you can see in the following article:
http://support.microsoft.com/default...b;en-us;301600
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Lapchien" <ccarswell@.nospameclipse.co.uk> wrote in message
news:11273pop2eunj40@.news.supernews.com...
> What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K
> cluster? Cluster is already setup and virtual sql instance running ok...
> Thanks
>
>
|||While we are on the subject of MSDTC within a SQL Cluster, Simon has
referred to the standard (in my mind superficial) documentation on MSDTC, I
am looking for more detailed information:
1. The detailed architecture and how a transaction enlists target
databases.
2. How the authentication and permissions work for MSDTC in detail
(e.g.. why Cluster permissions are required for services enlisting MSDTC in
a cluster).
I have configured several high-availability applications requiring
distributed transactions and fully understand the requirements for
successfully implementing MSDTC/SQL, however I would like to understand the
internal operations of MSDTC.
Regard
Gary Hope
"Simon Lidberg [MSFT]" <simonlid@.online.microsoft.com> wrote in message
news:eHmSQLeHFHA.896@.TK2MSFTNGP10.phx.gbl...
> MSDTC or the Microsoft Distributed Transaction Cordinator is used for
> distributed transactions.
> A good description of it can be found in SQL Server Books Online:
> http://msdn.microsoft.com/library/de...ar_cs_321x.asp
> As you can see in the following article; MS DTC is not required for the
> clustered SQL Server to work:
> http://support.microsoft.com/default...b;en-us;260758
> However if you have it installed on your server you need to run it in a
> clustered state as you can see in the following article:
> http://support.microsoft.com/default...b;en-us;301600
> Simon
> This posting is provided "as is" with no warranties and confers no rights.
> "Lapchien" <ccarswell@.nospameclipse.co.uk> wrote in message
> news:11273pop2eunj40@.news.supernews.com...
>