How can I migrate all objects alogwith all constraints,SP,Triggers etc from Development instance

Hi fellows,

I have to migrate all objects alogwith all constraints,SP,Triggers, indexes etc from Development instance to Production instance of a DB, all those things are created through wizard ie. Sql server 2000 Enterprise Manager. if i use DTS it only mirates data along with tables and views but constraints,SP,Triggers, indexes etc not yet copied.

can any body help me how can I solve this problem by copying all objects alogwith all constraints,SP,Triggers etc from Development instance to Production instance.

This is Sql server 2000 Cluster environment.

thanks in advance for any help

rahman

I would script all the objects out using Enterprise Manager and then run them all in the other environment.

-Jamie

|||

Dear Jamie

Thank you very much for your reply

would you like to give me a hence to write script for all the object's constraints (ie. Default,Check,Primary Key, Foreign Key etc) and indexes using Enterprise Manager.

I am new in SQL Server

Thanks in advance

|||

1. Right-click on an object.

2. Point at All tasks--> Generate SQL Script...

-Jamie

|||

Dear Jamie

Thanks for your reply.

I know this script only create table/view but not any constrains attached with it. As you know DTS also creates Table/views and imports the data too.

it'll not solve the problem, I m trying to write scripts for constraints getting info. from some views of Information_Schema.

|||

Thanks Jamie,

I didn't see the options available in Options Tab of All tasks--> Generate SQL Script

thank you very much

sql

How can I migrate all objects alogwith all constraints,SP,Triggers etc from Development inst

Hi fellows,

I have to migrate all objects alogwith all constraints,SP,Triggers, indexes etc from Development instance to Production instance of a DB, all those things are created through wizard ie. Sql server 2000 Enterprise Manager. if i use DTS it only mirates data along with tables and views but constraints,SP,Triggers, indexes etc not yet copied.

can any body help me how can I solve this problem by copying all objects alogwith all constraints,SP,Triggers etc from Development instance to Production instance.

This is Sql server 2000 Cluster environment.

thanks in advance for any help

rahman

I would script all the objects out using Enterprise Manager and then run them all in the other environment.

-Jamie

|||

Dear Jamie

Thank you very much for your reply

would you like to give me a hence to write script for all the object's constraints (ie. Default,Check,Primary Key, Foreign Key etc) and indexes using Enterprise Manager.

I am new in SQL Server

Thanks in advance

|||

1. Right-click on an object.

2. Point at All tasks--> Generate SQL Script...

-Jamie

|||

Dear Jamie

Thanks for your reply.

I know this script only create table/view but not any constrains attached with it. As you know DTS also creates Table/views and imports the data too.

it'll not solve the problem, I m trying to write scripts for constraints getting info. from some views of Information_Schema.

|||

Thanks Jamie,

I didn't see the options available in Options Tab of All tasks--> Generate SQL Script

thank you very much

How can I import table indices for all the tables transferred from one db to Sql Server?

Hello,
I was successfully able to import all the tables from a SQLBase db to MSSQL.
Now i would also like to import all the indexes for the tables.
How can I do that?
Regards,
Sami
[Remove Numbers from e-mail address to use it]
The only way I can think of would be if SQLBase has metadata tables from
which you can query for the indexes. You could query them and create
the CREATE INDEX statements required on SQL Server and then run them.
There is no part of Native DTS that will do this for you though.
Allan
"Sami" <s8a2m9i1_i5s1l9a6m@.hotmail.com> wrote in message
news:s8a2m9i1_i5s1l9a6m@.hotmail.com:

> Hello,
> I was successfully able to import all the tables from a SQLBase db to MSSQL.
> Now i would also like to import all the indexes for the tables.
> How can I do that?
> --
> Regards,
> Sami
> [Remove Numbers from e-mail address to use it]

How can I find the allocated size of an index?

I ran sp_statistics on a table and the indexes were displayed along with the
SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
table and the indexes SIZE's remained NULL. So what's the trick to obtain the
size of an indexe's allocation?
Thanks
Michael
Snake wrote:
> I ran sp_statistics on a table and the indexes were displayed along
> with the SIZE of the table, but the index SIZE's are NULL. I ran
> statistics on the table and the indexes SIZE's remained NULL. So
> what's the trick to obtain the size of an indexe's allocation?
> Thanks
> Michael
See "Estimating the Size of a Table with a Clustered Index" in BOL for
all required calculations.
David Gugick
Imceda Software
www.imceda.com
|||Try using sp_MSindexspace. It's not documented but it's reasonably simple.
It will give the size on nonclustered indexes.
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>I ran sp_statistics on a table and the indexes were displayed along with
>the
> SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> table and the indexes SIZE's remained NULL. So what's the trick to obtain
> the
> size of an indexe's allocation?
> Thanks
> Michael
|||Thanks Danny!
"DANNY SCROGGINS" wrote:

> Try using sp_MSindexspace. It's not documented but it's reasonably simple.
> It will give the size on nonclustered indexes.
>
> "Snake" <Snake@.discussions.microsoft.com> wrote in message
> news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>
>

How can I find the allocated size of an index?

I ran sp_statistics on a table and the indexes were displayed along with the
SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
table and the indexes SIZE's remained NULL. So what's the trick to obtain the
size of an indexe's allocation?
Thanks
MichaelSnake wrote:
> I ran sp_statistics on a table and the indexes were displayed along
> with the SIZE of the table, but the index SIZE's are NULL. I ran
> statistics on the table and the indexes SIZE's remained NULL. So
> what's the trick to obtain the size of an indexe's allocation?
> Thanks
> Michael
See "Estimating the Size of a Table with a Clustered Index" in BOL for
all required calculations.
--
David Gugick
Imceda Software
www.imceda.com|||Try using sp_MSindexspace. It's not documented but it's reasonably simple.
It will give the size on nonclustered indexes.
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>I ran sp_statistics on a table and the indexes were displayed along with
>the
> SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> table and the indexes SIZE's remained NULL. So what's the trick to obtain
> the
> size of an indexe's allocation?
> Thanks
> Michael|||Thanks Danny!
"DANNY SCROGGINS" wrote:
> Try using sp_MSindexspace. It's not documented but it's reasonably simple.
> It will give the size on nonclustered indexes.
>
> "Snake" <Snake@.discussions.microsoft.com> wrote in message
> news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
> >I ran sp_statistics on a table and the indexes were displayed along with
> >the
> > SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> > table and the indexes SIZE's remained NULL. So what's the trick to obtain
> > the
> > size of an indexe's allocation?
> >
> > Thanks
> >
> > Michael
>
>

How can I find the allocated size of an index?

I ran sp_statistics on a table and the indexes were displayed along with the
SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
table and the indexes SIZE's remained NULL. So what's the trick to obtain th
e
size of an indexe's allocation?
Thanks
MichaelSnake wrote:
> I ran sp_statistics on a table and the indexes were displayed along
> with the SIZE of the table, but the index SIZE's are NULL. I ran
> statistics on the table and the indexes SIZE's remained NULL. So
> what's the trick to obtain the size of an indexe's allocation?
> Thanks
> Michael
See "Estimating the Size of a Table with a Clustered Index" in BOL for
all required calculations.
David Gugick
Imceda Software
www.imceda.com|||Try using sp_MSindexspace. It's not documented but it's reasonably simple.
It will give the size on nonclustered indexes.
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>I ran sp_statistics on a table and the indexes were displayed along with
>the
> SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> table and the indexes SIZE's remained NULL. So what's the trick to obtain
> the
> size of an indexe's allocation?
> Thanks
> Michael|||Thanks Danny!
"DANNY SCROGGINS" wrote:

> Try using sp_MSindexspace. It's not documented but it's reasonably simple
.
> It will give the size on nonclustered indexes.
>
> "Snake" <Snake@.discussions.microsoft.com> wrote in message
> news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>
>