Thursday, March 8, 2012

copy data from one db to an other db

Hello,

there is a database with an table x and I want a copy of that in my testdatabase.

I am pretty sure, that I have done that the whole last week, but it's not working anymore.

I thinkt, that last time I used a statement like that to copy the table with structure and all.

insert into dbtest.dbo.x select * from db.dbo.x

Today it's only telling me, that the destinationtabel x is not present.
The table has about 100 fields and I swear, I didnt create it by hand in the testdatabase, I'm definitely too lazy for that.
I can't use the enterprise manager, I only can use sql.

There are still tables in my testdatabase, I copied last week. So what is wrong with my insert into?I am to f*ing stupid. The weekend canceled all my sql knowledge.
It is select * into , not insert into.

sorry for the hassle.

No comments:

Post a Comment