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
On 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.googlegro ups.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
Showing posts with label database1. Show all posts
Showing posts with label database1. Show all posts
Monday, March 12, 2012
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
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
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
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
Subscribe to:
Posts (Atom)