Question About Scripting Objects

Hello all,

I was just using Management Studio to script objects on one server to create on another server and I noticed an issue that I need assistance with. When you right-click a table and choose to Script Table As --> Create To --> ..., it scripts the Create Table fine, but if the table has any Primary Keys, Foreign Keys, Constraints, etc., these objects don't get scripted with the Create Table. You have to manually script these objects as well.

I believe in SQL Server 2000, you had the choice of which objects to get created when you wanted to generate the script. Is there an easy way to do this in SSMS? If so, how?

Thanks,

Jason

Nevermind ... it's working now. The developer was adding the PK to the table while I was scripting it so there wasn't a PK to generate at the time of my scripting. Once he added the PK, I was able to generate the script, which included the PK as part of the Create script.

Jason

|||

I have a similar problem. I need to create scripts with the DROP object syntax at the top. This was possible in SQL-2000.

Any help in setting these options for SQL-2005 would be great.

-Rajiv

|||

Rajiv,

I think in SQL Server 2005 you have to generate the DROP independent of the CREATE. I don't think there is an option to generate both commands at once like there was in SQL Server 2000. I could be wrong though, but I haven't been able to find anything comparable in SQL Server 2005. Maybe Microsoft will correct that in a future service pack.

Jason

sql

Question About Scripting Objects

Hello all,

I was just using Management Studio to script objects on one server to create on another server and I noticed an issue that I need assistance with. When you right-click a table and choose to Script Table As --> Create To --> ..., it scripts the Create Table fine, but if the table has any Primary Keys, Foreign Keys, Constraints, etc., these objects don't get scripted with the Create Table. You have to manually script these objects as well.

I believe in SQL Server 2000, you had the choice of which objects to get created when you wanted to generate the script. Is there an easy way to do this in SSMS? If so, how?

Thanks,

Jason

Nevermind ... it's working now. The developer was adding the PK to the table while I was scripting it so there wasn't a PK to generate at the time of my scripting. Once he added the PK, I was able to generate the script, which included the PK as part of the Create script.

Jason

|||

I have a similar problem. I need to create scripts with the DROP object syntax at the top. This was possible in SQL-2000.

Any help in setting these options for SQL-2005 would be great.

-Rajiv

|||

Rajiv,

I think in SQL Server 2005 you have to generate the DROP independent of the CREATE. I don't think there is an option to generate both commands at once like there was in SQL Server 2000. I could be wrong though, but I haven't been able to find anything comparable in SQL Server 2005. Maybe Microsoft will correct that in a future service pack.

Jason

Question about deploying DTS objects (COM, DTSRUN.exe, etc.).

Hello all!
I have a series of file-based DTS packages that I want to execute from our
web servers, and I have a couple of questions about the deployment of the
objects necessary to support these packages.
In my DTS packages, I have some ActiveX scripts that do some "package
manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
DTS COM objects to be installed and registered on the web servers?
Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
servers, so I'd probably need to install that (and any dependencies?) on the
Web servers.
I'm not really sure which files I need, or where to start looking. Are
there any licensing issues involved with having the DTS components on our
production web servers?
I'd be grateful for any assistance anyone can provide! :-)
John PetersonThis article is helpful
Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hello all!
> I have a series of file-based DTS packages that I want to execute from our
> web servers, and I have a couple of questions about the deployment of the
> objects necessary to support these packages.
> In my DTS packages, I have some ActiveX scripts that do some "package
> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
> DTS COM objects to be installed and registered on the web servers?
> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
> servers, so I'd probably need to install that (and any dependencies?) on
> the Web servers.
> I'm not really sure which files I need, or where to start looking. Are
> there any licensing issues involved with having the DTS components on our
> production web servers?
> I'd be grateful for any assistance anyone can provide! :-)
> John Peterson
>|||Thanks Allan! I had *just* chanced upon that link when you replied. :-)
I notice that there's no mention of any licensing issues. Do you have any
suggestions regarding that?
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
> This article is helpful
> Redistributing DTS with your program
> (http://www.sqldts.com/default.aspx?225)
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
>|||Licencing - yuck.
Have a look in redist.txt.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:ubodiFTbFHA.1148@.tk2msftngp13.phx.gbl...
> Thanks Allan! I had *just* chanced upon that link when you replied. :-)
> I notice that there's no mention of any licensing issues. Do you have any
> suggestions regarding that?
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
>

Question about deploying DTS objects (COM, DTSRUN.exe, etc.).

Hello all!
I have a series of file-based DTS packages that I want to execute from our
web servers, and I have a couple of questions about the deployment of the
objects necessary to support these packages.
In my DTS packages, I have some ActiveX scripts that do some "package
manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
DTS COM objects to be installed and registered on the web servers?
Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
servers, so I'd probably need to install that (and any dependencies?) on the
Web servers.
I'm not really sure which files I need, or where to start looking. Are
there any licensing issues involved with having the DTS components on our
production web servers?
I'd be grateful for any assistance anyone can provide! :-)
John PetersonThis article is helpful
Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hello all!
> I have a series of file-based DTS packages that I want to execute from our
> web servers, and I have a couple of questions about the deployment of the
> objects necessary to support these packages.
> In my DTS packages, I have some ActiveX scripts that do some "package
> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
> DTS COM objects to be installed and registered on the web servers?
> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
> servers, so I'd probably need to install that (and any dependencies?) on
> the Web servers.
> I'm not really sure which files I need, or where to start looking. Are
> there any licensing issues involved with having the DTS components on our
> production web servers?
> I'd be grateful for any assistance anyone can provide! :-)
> John Peterson
>|||Thanks Allan! I had *just* chanced upon that link when you replied. :-)
I notice that there's no mention of any licensing issues. Do you have any
suggestions regarding that?
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
> This article is helpful
> Redistributing DTS with your program
> (http://www.sqldts.com/default.aspx?225)
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> Hello all!
>> I have a series of file-based DTS packages that I want to execute from
>> our web servers, and I have a couple of questions about the deployment of
>> the objects necessary to support these packages.
>> In my DTS packages, I have some ActiveX scripts that do some "package
>> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need
>> the DTS COM objects to be installed and registered on the web servers?
>> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
>> servers, so I'd probably need to install that (and any dependencies?) on
>> the Web servers.
>> I'm not really sure which files I need, or where to start looking. Are
>> there any licensing issues involved with having the DTS components on our
>> production web servers?
>> I'd be grateful for any assistance anyone can provide! :-)
>> John Peterson
>>
>|||Licencing - yuck.
Have a look in redist.txt.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:ubodiFTbFHA.1148@.tk2msftngp13.phx.gbl...
> Thanks Allan! I had *just* chanced upon that link when you replied. :-)
> I notice that there's no mention of any licensing issues. Do you have any
> suggestions regarding that?
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
>> This article is helpful
>> Redistributing DTS with your program
>> (http://www.sqldts.com/default.aspx?225)
>> --
>>
>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> www.SQLDTS.com - The site for all your DTS needs.
>> www.SQLIS.com - You thought DTS was good. here we show you the new
>> stuff.
>> www.konesans.com - Consultancy from the people who know
>>
>> "John Peterson" <j0hnp@.comcast.net> wrote in message
>> news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> Hello all!
>> I have a series of file-based DTS packages that I want to execute from
>> our web servers, and I have a couple of questions about the deployment
>> of the objects necessary to support these packages.
>> In my DTS packages, I have some ActiveX scripts that do some "package
>> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need
>> the DTS COM objects to be installed and registered on the web servers?
>> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
>> servers, so I'd probably need to install that (and any dependencies?) on
>> the Web servers.
>> I'm not really sure which files I need, or where to start looking. Are
>> there any licensing issues involved with having the DTS components on
>> our production web servers?
>> I'd be grateful for any assistance anyone can provide! :-)
>> John Peterson
>>
>>
>

Question about deploying DTS objects (COM, DTSRUN.exe, etc.).

Hello all!
I have a series of file-based DTS packages that I want to execute from our
web servers, and I have a couple of questions about the deployment of the
objects necessary to support these packages.
In my DTS packages, I have some ActiveX scripts that do some "package
manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
DTS COM objects to be installed and registered on the web servers?
Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
servers, so I'd probably need to install that (and any dependencies?) on the
Web servers.
I'm not really sure which files I need, or where to start looking. Are
there any licensing issues involved with having the DTS components on our
production web servers?
I'd be grateful for any assistance anyone can provide! :-)
John Peterson
This article is helpful
Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hello all!
> I have a series of file-based DTS packages that I want to execute from our
> web servers, and I have a couple of questions about the deployment of the
> objects necessary to support these packages.
> In my DTS packages, I have some ActiveX scripts that do some "package
> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
> DTS COM objects to be installed and registered on the web servers?
> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
> servers, so I'd probably need to install that (and any dependencies?) on
> the Web servers.
> I'm not really sure which files I need, or where to start looking. Are
> there any licensing issues involved with having the DTS components on our
> production web servers?
> I'd be grateful for any assistance anyone can provide! :-)
> John Peterson
>
|||Thanks Allan! I had *just* chanced upon that link when you replied. :-)
I notice that there's no mention of any licensing issues. Do you have any
suggestions regarding that?
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
> This article is helpful
> Redistributing DTS with your program
> (http://www.sqldts.com/default.aspx?225)
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
>
|||Licencing - yuck.
Have a look in redist.txt.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:ubodiFTbFHA.1148@.tk2msftngp13.phx.gbl...
> Thanks Allan! I had *just* chanced upon that link when you replied. :-)
> I notice that there's no mention of any licensing issues. Do you have any
> suggestions regarding that?
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
>