Copy or insert Columns from a table in another Database, How?

Hallo,
I thought it is easily done, but no. I have 3 columns of hundreds of data i
n a table in another Database within thesame server that i want to move to m
y production Database. I have tried Select into, copy, insert method... wit
hout success.
Please help.
ThanksHi,
If the structure of the table in production database is identical then use
Insert into
Insert into productiondatabase..table_name(col1,col2,col3) select
col1,col2,col3 from devdb..table
Above command will fail incase the same table have any other column which
will not allow "NOT NULL"
I have tried Select into, copy, insert method... without success.
Tell the error you are getting.
Thanks
Hari
MCDBA
"Ototofioto" <anonymous@.discussions.microsoft.com> wrote in message
news:6ED03A97-26F9-483A-93B9-3BFB8F28C87D@.microsoft.com...
> Hallo,
> I thought it is easily done, but no. I have 3 columns of hundreds of data
in a table in another Database within thesame server that i want to move to
my production Database. I have tried Select into, copy, insert method...
without success.
> Please help.
> Thanks

Copy diagram from one MSSQL db to another

Hallo,
The subj actually says it all. I have developed the database locally, and
added a nicley formatted diagram to it, and would like to spare the
possibility to remake it once again on another database that has exactly the
same structure. So, there must be some way to copy the diagram from here to
there. I'd appreciate if someone could hint me how that could be possible to
achieve.
Thank you,
-- PavilsThe following article explains how to do it:
HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125
-Sue
On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
<pavils@.mailbox.riga.lv> wrote:

>Hallo,
>The subj actually says it all. I have developed the database locally, and
>added a nicley formatted diagram to it, and would like to spare the
>possibility to remake it once again on another database that has exactly th
e
>same structure. So, there must be some way to copy the diagram from here to
>there. I'd appreciate if someone could hint me how that could be possible t
o
>achieve.
>Thank you,
>-- Pavils
>|||Thanks, that works well. Luckily, I have only one diag to copy and the
destination database does not contain any diagrams. There could be
complications using this copy *.* approach on some finer cases.
-- Pavils
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s279401gpnvhr8892a3s1gq7rsqoi4rnpl@.
4ax.com...
> The following article explains how to do it:
> HOW TO: Move a Database Diagram
> http://support.microsoft.com/?id=320125
> -Sue
> On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
> <pavils@.mailbox.riga.lv> wrote:
>
the
to
to
>sqlsql

Copy diagram from one MSSQL db to another

Hallo,
The subj actually says it all. I have developed the database locally, and
added a nicley formatted diagram to it, and would like to spare the
possibility to remake it once again on another database that has exactly the
same structure. So, there must be some way to copy the diagram from here to
there. I'd appreciate if someone could hint me how that could be possible to
achieve.
Thank you,
-- PavilsThe following article explains how to do it:
HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125
-Sue
On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
<pavils@.mailbox.riga.lv> wrote:
>Hallo,
>The subj actually says it all. I have developed the database locally, and
>added a nicley formatted diagram to it, and would like to spare the
>possibility to remake it once again on another database that has exactly the
>same structure. So, there must be some way to copy the diagram from here to
>there. I'd appreciate if someone could hint me how that could be possible to
>achieve.
>Thank you,
>-- Pavils
>|||Thanks, that works well. Luckily, I have only one diag to copy and the
destination database does not contain any diagrams. There could be
complications using this copy *.* approach on some finer cases.
-- Pavils
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:s279401gpnvhr8892a3s1gq7rsqoi4rnpl@.4ax.com...
> The following article explains how to do it:
> HOW TO: Move a Database Diagram
> http://support.microsoft.com/?id=320125
> -Sue
> On Tue, 2 Mar 2004 16:31:13 +0200, "Pavils Jurjans"
> <pavils@.mailbox.riga.lv> wrote:
> >Hallo,
> >
> >The subj actually says it all. I have developed the database locally, and
> >added a nicley formatted diagram to it, and would like to spare the
> >possibility to remake it once again on another database that has exactly
the
> >same structure. So, there must be some way to copy the diagram from here
to
> >there. I'd appreciate if someone could hint me how that could be possible
to
> >achieve.
> >
> >Thank you,
> >
> >-- Pavils
> >
>

Copy database

Hallo !!!
I have MS SQL Server 2000
How I can copy database but only structure (without data).
allways when I copy this structure of database then I see "Failed to copy
from ms sql server to ms sql server"
WHY ?
pawelThis was answered in .programming, try not to multi-post.
Ray Higdon MCSE, MCDBA, CCNA
--
"Pawel" <admin@.channoine.pl> wrote in message
news:eOpsKoy8DHA.3008@.TK2MSFTNGP09.phx.gbl...
> Hallo !!!
> I have MS SQL Server 2000
> How I can copy database but only structure (without data).
> allways when I copy this structure of database then I see "Failed to copy
> from ms sql server to ms sql server"
> WHY ?
> pawel
>

Copy database

Hallo !!!
I have MS SQL Server 2000
How I can copy database but only structure (without data).
allways when I copy this structure of database then I see "Failed to copy
from ms sql server to ms sql server"
WHY ?
pawelThis was answered in .programming, try not to multi-post.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Pawel" <admin@.channoine.pl> wrote in message
news:eOpsKoy8DHA.3008@.TK2MSFTNGP09.phx.gbl...
> Hallo !!!
> I have MS SQL Server 2000
> How I can copy database but only structure (without data).
> allways when I copy this structure of database then I see "Failed to copy
> from ms sql server to ms sql server"
> WHY ?
> pawel
>