move settings from Database1 to Database2

Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
have two DataBases.
Database1
-Tables <- (with data and settings like Key and Constraints)
-Views
-Stored Procedure
Database2
-Tables < with Data
my question is:
how can i move Views\Stored Procedure and the Table Settings like KEY
and Constraints to the Database2 and keep the Data in the Tables of
Database2
best regards Jarosaw KucharskiOn Feb 19, 12:18 pm, jaroslaw.kuchar...@.3dac.net wrote:
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
for views and proc you can generate a script. No Idea on keys and
constraints.
~Shiju|||Hi
You can generate ascript of those objects (for SP and Views) and just run it
on destination database
In case of tables , (script out all keys and contraints ) use alter
table... command to create contsraints (for more details please read BOL)
<jaroslaw.kucharski@.3dac.net> wrote in message
news:1171869504.143391.31440@.t69g2000cwt.googlegroups.com...
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
>
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
>|||Hi
"jaroslaw.kucharski@.3dac.net" wrote:

> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
>
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
>
If you want an exact copy of Database1 named Database2 you can
backup/restore the database giving the destination database a different name
and renaming the data and log files if necessary see
http://support.microsoft.com/kb/314546
If you only want to transfer a subset of objects then you could use the
Import/Export wizard (i.e. DTS). DTS could also be used for periodic
refreshes of the data.
HTH
John