How To Copy Data From One....

May 26, 2008

hi

How to copy data from one column(field) to another column(field).

I have two column colA & ColB
Both column have data.

but i want to replace all ColB data with ColA.

it is like this,
COLA COLB
abcd grfr
dfere kieidk
fere fkerie

but, I want like this
COLA COLB
abcd abcd
dfere dfere
fere fere

please help me

View 2 Replies


ADVERTISEMENT

How To Copy Data From Backup Or Data Files To New SQL Installation?

Dec 10, 2005

Hi,I have(had) an old Win2k Server server with about 30 web site databases(SQL 2000) that just went under due to hardware problems. Thankfully, Ihave backups of all the databases plus the MDF and LDF files from thehard drive.I want to move all of these sites and their data to a newer server(Win2003) running SQL2000.What's the best way to copy the database from the old server hard drive(now mounted as an extrnal drive to a local machine; I'm currentlyFTPing all of the web site directories from it to the new server)?Just upload the original data to the new server and then mount the MDFand LDF files within the new SQL server? Or do I restore the backupfiles in the new SQL2000?All of my previous data migrations have been DTS operations from onelive server to another, so no experience with either of the abovescenarios. I'll certainly have a lot more experience at one of them bythe time this weekend is through.Thanks for any help you can offer.

View 1 Replies View Related

Bulk Copy XML Data To SQL Data Source

Aug 12, 2006

Can anyone provide an expample of bulk copying XML data to a SQL table. I am also looking at using column mapping so that I can map fields and also insert a new GUID into the key of the SQL table.
Many thanks

View 1 Replies View Related

Copy Data From 1 Tbl To Another Tbl

Dec 5, 2005

i have a claims_tbl that i am inserting into with claim information, the tbl contains a claim_seq number that i want  to copy over to a  user_info_tbl at the same time insert user information below is what i have tried with no luck
insert into user_info(claim_seq) select Max(claim_seq) from claim_tbl 
update user_info  set  lname =upper(@lname), fname =upper(@fname), mname =upper(@mname), personnel = @personnel, p_position =upper(@position)where claim_seq = (Select Max(claim_seq) from user_info)
i am getting duplicate rows of information ..........can someone help
 
thanks
 
 

View 2 Replies View Related

Copy Data

Jul 25, 2001

Hi!
What is the best way to copy data from SQL server to Access database located on differet machines?
Thank you,
Elena.

View 1 Replies View Related

Copy Data From One Db To An Other Db

Sep 11, 2006

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?

View 1 Replies View Related

Copy Db W/o Data

Apr 7, 2008

All,
Does anyone have amethod for copying db(all tables, procs etc..) but without the data. Scripting is not feasible because of number of objects constraints ..etc...

any help would be appreciated
thanks,
JB

View 6 Replies View Related

Cant Copy Data From One DB To Another.

Oct 6, 2005

I am trying to copy item names from one database to another if they share the same code number.
e.g.

UPDATE TABLE1
SET NAME = DB2.TABLE2.NAME
WHERE CODE = DB2.TABLE2.CODE

I dont know how to specify the second db as using a '.' here doesnt seem to work. I have also tried '..' and DB2.dbo.TABLE2 but get the same error - 'The column prefix 'Train_DB_FinancialsProd.dbo.ITEM_DEFINITIONS' does not match with a table name or alias name used in the query.'

I have checked that the spelling is ok so not sure why it doesnt work.


I have also tried using a temp db in between to copy the values across then try to update from the temp table but couldnt make that work either. e.g.

create table #tdhname
(
code char(50),
name char(100)
)


INSERT INTO #tdhname (code,name)
select distinct code,name from Train_DB_FinancialsProd..item_definitions tritm
where code = tritm.code
and tritm.ittyp_refno = 241

update pharmacy_items
set name = #tdhname.name <----- THIS DOESNT WORK
where #tdhname.code = code



Thanks!

View 5 Replies View Related

How Can I Copy Data

Jul 23, 2005

hi their,How can i copy data in MS-SQL 2000 from one table to another withdifferent charactristic?thanks*** Sent via Developersdex http://www.developersdex.com ***

View 3 Replies View Related

Data Copy

Mar 10, 2008

Help!!! I am trying to consolidate 5000 odd databases. Each database contains hundreds of tables. The tables in each database are identical to the tables in all of the other databases. Sounds simple doesn't it? However, SSIS has defied every trick that I have applied to this task including changing connectionstrings at run time through package configuration. has anyone out there ever tackled a similar challenge?. Please let me know

Desperate

View 7 Replies View Related

How Can I Copy SQL Express Data?

Dec 5, 2007

I have SQL Server Express installed on my local development machine and on a remote server.  I have identical databases set up on each.  How can I copy the data from one to the other?  How can I copy the data from one to SQL Server 2005?  And can I create an Access database from SQL Server Express? Diane 

View 3 Replies View Related

How Can I Copy Data To/from SQL Express?

Dec 5, 2007

I have SQL Server Express installed on my local development machine
and on a remote server.  I have identical databases set up on each and I'm trying to keep them co-ordinated to make testing easier. 
How can I copy the data from one to the other?  How can I copy the data
from one to SQL Server 2005?  And can I create an Access database from
SQL Server Express?Diane

View 9 Replies View Related

Copy A Table With Its Data From A Db To Another

Dec 16, 2007

Hi: At the moment,  I know how to copy a db to another (create a .bak file), but I am not sure what is the best way to copy one the table (with it data) from a db to another.Would u please give some links or suggestions?Thanks.jt 

View 4 Replies View Related

Need To Copy Data From Access To SQL

Dec 31, 2007

I am creating an ASP.Net project at work and have created a database in Microsoft SQL Server 2005.  I need to copy data from an old database (which is in Access) that the company has used for years.  The problem is that these databases are not very similar (the Access database is not normalized at all).  My question is simply this -- is there an easy way to do this.  I would like to avoid writing a lot of code if possible as this will only run one time.  Any help would be appreciated.  Thanks.

View 1 Replies View Related

Copy Data From One Table To Another From 2 Db's.

Jan 17, 2008

i have a table called t_CustomerAcct in 'Dev' db and want to copy the data in t_CustomerAcct table in 'Production' db.
but i have some records in the table in 'production' db which i dont want to be updated. my primary key in both tables is 'email'
i bit lost on how to do this and i dont want to loose any data from production db accidentally.
 
 

View 1 Replies View Related

Copy Data From One Column To Another

Jun 6, 2008

Hi,
I have two users tables. One users table has a deleted column. The other users table is made up of users based on what dept they are in etc. I would like to get the values from a column (deleted) in the first table and copy the values over to a column in the second table.
I would appreciate any suggestions you might have.
Regards,
Tony.

View 2 Replies View Related

Copy Data Base ...

Aug 23, 2005

hi
i want copy Data base fron 2 sql server2000 in the same network. so i want copy all object(table,users,diagrams,....)

View 1 Replies View Related

Copy Data Issue

Oct 14, 2004

I need to create a new field and copy over an existing field from the same table. Since this table is about 3 million rows. It will take about 1 hour 30 minutes to complete.

Any good way around?


Thanks!

-J8

-----------------------------------------
UPDATE Customer SET ColB = ColA WHERE ColA IS NOT NULL

View 3 Replies View Related

Bulk Copy Data

Dec 6, 2004

Dear All,

Can anyone tell me what's the best/easiest way to copy one column of data from one table to another column of another table.

Thanks in advance.

View 3 Replies View Related

How To Copy Data Across Databases

Jan 21, 2005

I am trying to copy information from one Database to another. Each of the databases reside on a different server.

My question is
1. How can I use the DSN name in a stored procedure?
2. Do I need to use dynamic SQL?
3. Any other ideas of how to implement this?

Thanks

View 1 Replies View Related

Copy Data From 2 Tables

Aug 24, 2006

I need to copy the data in the last name table to the field2 table do i use the update query in sql 2005?

View 5 Replies View Related

Copy Data From One Table To Another...

Jan 10, 2007

hi. i'm trying to copy data from one table to another. the table has already been created but i just want to update some of the information in it.

here is what i have:

INSERT INTO DefendantCaseBAK

SELECT * FROM DefendantCase WHERE DefendantCase.StatusID=2
when i run this query, i get this error:
The column prefix 'DefendantCaseBAK' does not match with a table name or alias name used in the query.
what am i doing wrong? i looked up some examples on the internet and i copied them exactly. thanks for your help!

View 6 Replies View Related

Copy Data From One Column To Another

Apr 17, 2008

Hi,

I want to copy data from one column to another column within the same table. I used 'Select subquery' but no success yet.

any help.

Thanks

View 1 Replies View Related

Copy Data From One Table To Another

Jun 2, 2008

I need to move data from a large table (350GB/395,000 rows) to another table within the DB, but onto another disk. The table has an image data type so I have to create a new table onto the new disk. My original table looks like this:

USE [PD51_Data]
GO
/****** Object: Table [dbo].[SCANNEDDOCUMENTS] Script Date: 05/27/2008 11:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SCANNEDDOCUMENTS](
[DocID] [int] IDENTITY(1,1) NOT NULL,
[CaseID] [int] NOT NULL,
[DocName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Doc] [image] NOT NULL,
[DocLocation] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DocNotes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TopicID] [int] NULL,
[ScannedDocumentsCheckSum] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
PRIMARY KEY CLUSTERED
(
[DocID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[SCANNEDDOCUMENTS] WITH NOCHECK ADD CONSTRAINT [ISCANNEDDOCUMENTS2] FOREIGN KEY([TopicID])
REFERENCES [dbo].[TOPICS] ([TopicID])
GO
ALTER TABLE [dbo].[SCANNEDDOCUMENTS] CHECK CONSTRAINT [ISCANNEDDOCUMENTS]

My new table looks like this:
USE [PD51_Data]
GO
/****** Object: Table [dbo].[SCANNEDDOCUMENTS2] Script Date: 05/27/2008 11:27:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SCANNEDDOCUMENTS2](
[DocID] [int] IDENTITY(1,1) NOT NULL,
[CaseID] [int] NOT NULL,
[DocName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Doc] [image] NOT NULL,
[DocLocation] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DocNotes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TopicID] [int] NULL,
[ScannedDocumentsCheckSum] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [SECONDARY] TEXTIMAGE_ON [SECONDARY]

GO
SET ANSI_PADDING OFF

My plan was to use import/export wizard to move the data over to the new table, while set to Bulk Log recovery, drop the original table, then create the indexes/constraints on the new one.
With this much data, I'm wondering what else I should do.
Anyone have a better idea? What am I missing?

View 7 Replies View Related

How To Copy Some Data Into Same Table

Sep 11, 2013

There are some data in a table with TypeID=23 and I need copy all rows with TypeID=23 to the same table, I mean append at the end, and make the copied rows TypeId=24 for some tests purpose.

View 3 Replies View Related

How To Copy Data From One Table To Another

Mar 9, 2014

I have a table Product BasicInfo, which has following fields:

ProdID (PK)
ProdName
Description
Manufacturer
Store
ProdPrice

Now i have another table TempPrice, having fields:

TempID (PK)
ProdID (FK)
TempProdPrice

TempPrice table has the original values, which are needed to copy into ProductBasicInfo column "ProdPrice" (which is entire NULL column so far).

View 5 Replies View Related

Copy Data From One Table To Another

Oct 16, 2014

Write a query that will grab bin# from table A and if its missing on table B copy it. I tried and update query but it doesn't work and also a select Into and failed too.

Table_A

idx Bin
1 CSR010101A
2 CSR010101B
3 CSR010102A
4 CSR010102B
5 CSR010201A
6 CSR010201B
7 CSR010202A
8 CSR010202B

Table_B

idx Bin
1 CSR010101A
2 CSR010101B
3 Null
4 Null
5 CSR010201A
6 Null
7 CSR010202A
8 NUll

View 1 Replies View Related

Copy Tables And Data

Mar 1, 2006

how can i copy all table and data to another database

View 3 Replies View Related

Copy A Row Of Data From One Table To Another

Jun 8, 2006

Hello,

I want to move or copy a row of data from one table to another, but not sure how to go about it! I have SQL 2000, and using Enterprise Mangager with SQL query to run the script. This will be used in a procedure once I get the Query to work.

Thank you,

Ernie

View 7 Replies View Related

Copy Data From Old To New Table

Apr 3, 2007

Hi All
I have two tables one is old and another new table.
I need to copy the data from old to new table.
using stored procedure.
How can I do the same.
Please help me.

Thanks

View 3 Replies View Related

Fastest Way To Copy Data?

May 22, 2007

I've got a view that is driven from a 80 million record table in a data warehouse. I am trying to populate an aggregate table in a datamart, but am running into preformance problems. The datamart table needs to be updated daily. I understand there are many factors that effect performance, but in general would the fastest approach be:
1) Truncate the datamart table
2) Perform a bcp of the view to a text file
3) Bulk Insert to the datamart table

If you need more information to answer this please let me know.

Thanks,

Matt

View 7 Replies View Related

Data Source Fax Copy

Jul 9, 2007

Can integration services be used to import data from a fax copy?

View 1 Replies View Related

Copy Data From Old DB To New DB Having Schema Changes

May 20, 2008

Hi All,

I want to migrate data from old DB to New DB. New db is having schema changes. For e.g Table A in Old DB is split into

two tables A1 and A2 in new DB. I want to copy some columns from Table A to A1 and some into A2. A2 is having relation with A1(A1's ID is FK in A2). I want to insert records into A1 and using the identity column of newly inserted record, i want to insert the record into A2. Please guide me how can i do this with SSIS.

Thanks in Advance
Devika

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved