|
|
MSSQL
Started by octavioCancun at 04-25-2008 11:39 AM. Topic has 1 replies.
  
|
|
Sort Posts:
|
|
|
|
 04-25-2008, 11:39 AM
|
octavioCancun
Joined on 04-26-2008
Posts 1
|
insert record from a table en Database X to other table in other Databse Y
|
|
|
|
|
Hello, I need copy record from onces of my 3 databse that i have in my site to other database in my same site.
I tray use opendatasource, but for segurity rason they in sql2005 have desabilitado,
this is very usfull, if you have a big database en every month you need add more records that you have in other litte table you down de little database and put new record der then up this and copy to the big one. tanks sorry my engles is pretty bat
|
|
|
|
|
Report
|
|
|
|
|
07-24-2008, 10:56 AM
|
SturdyErde
Joined on 04-09-2008
Maine
Posts 101
|
Re: insert record from a table en Database X to other table in other Databse Y
|
|
|
|
|
|
I have not tried that on this host. Are your records in 3 separate databases, or 3 tables in the same database? If you have 3 tables in one database, you should be able to use an APPEND query to copy the records. I'm not sure how you would do it if the records are in separate databases.
Good effort on the English. Google Translator could probably help, but I will try to help as well:
once = eleven = 11 en englais
uno = one = 1
segurity = security
rason = reason
desabilitado = disabled
de = from
:)
|
|
|
|
|
Report
|
|
|
|
|
Webhost4life Fo... » Database Relate... » MSSQL » insert record from a table en Database X to other table in other Databse Y
|
|
|
|