a little help with transfering table A in Database A into table B in database B

I can't seem to find a good tutorial in transfering data from one table in database a into a different table in database b. The catch is that the fields in the tables don't match exactly.

How can I do this? Examples, tutorials, etc are greatly appreciated.

Thanks!


Graphfixz Data & Web Design
http://www.graphfixz.com
0
Graphfixz
9/16/2006 3:13:27 PM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

1 Replies
913 Views

Similar Articles

[PageSpeed] 28

All you need is INSERT INTO with column list that will give you control of how you the the insert into the new database, the other option was to use DTS.  Try the link below for the INSERT INTO statement.  Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_5cl0.asp


Kind regards,
Gift Peddie
0
Caddre
9/17/2006 3:03:03 AM
Reply:

Similar Artilces:

Link FoxPro Database table to SQL Server Database table
I have LAN Server in witch Visual Foxpro Database reside.I have another remote server in witch SQL Server 2005 installed.I want to link Foxpro table to SQL Server Database Table.Is it possible? Can please someone help? Thanks MS...

Transfer tables and other contents from access database to sql database
Hi All, can anyone please help me to transfer tables and other contents from access database to sql database? I have access database file, can I also directly convert it into a sql database file? You can upsize your Access database to an SQL Server database (In Access, Tools>>Database Utilities>>Upsize Wizard.... follow the screen. Or you can use SQL Server's Import and Export wizard to import your access database to SQL Server.   You cannot convert your Access database file to SQL Server data file directly.Limno  Read this http://support.microsoft.com/kb/23...

how to transfer the data from table A to table B OR FROM EXCEL TO TABLE I NEED
Hi all,I am trying to transfer the data in the excel file to the SQL 2005 database .i am able to transfer the data into database, but into new table the table i need.can anybody help to transfer the whole data from the excel to the table i need or from one table to another.i would appreciate if anyone can help. TABLE A -----> TABLE BOREXCEL -----> TABLE I NEEDOR EXCEL ---->TABLE A -----> TABLE B  CheersDivikiran   right click database, select tasks-> import/export data ( depends on your requirements) select source and destination. (if from excel to ...

Database Synchronization (Transfer Database, not tables)...
I wonder what objects do we use the .NET Compact Framework with the ulnet10.dll to do those database synchronizations stuffs. Is the MobLink already included in the ulnet10.dll? I don't want the synchronization to be about mirroring the data between teh database on the Mobile/Pda and the PC. I just want it to transfer a fresh/new database from the PC to the PDA via deleting an database on the PDA and put a new one on the PDA. The reason is because the database design will continue to change such as new tables, dropped field name, etc. How can this be done? Thanks......

I imported a SQL Table into SQL DataBase, But I can not update this table even with SQL Server management Studio
I imported a SQL Table into SQL DataBase, But I can not update this table even with SQL Server management Studio When I change any data on mentioned table above, Red exclamation sign appears left of the record . How can I correct this problem?  Thanks. Try running the UPDATE via Query Analyzer...and see if you get an error.***********************Dinakar NethiLife is short. Enjoy it.***********************...

Move a Table from one SQL 2005 Database to Another SQL 2005 Database
I created a table in an SQL 2005 database, however, I want to move that table and the data to another SQL 2005 database (within the same server). I am new to SQL 2005 and detailed instructions would be greatly appreciated. Thanks Bill You have two options the first is clean but the second is easier.  Try the links below for details.  Hope this helps. http://msdn2.microsoft.com/en-us/library/ms174335.aspx http://msdn2.microsoft.com/en-us/library/ms188029.aspx  Kind regards,Gift Peddie Thanks, but the documentations is somewhat overwhelming and was hoping of a ba...

Table transfer from one Database to another Database
Hi,I want to transfer one table to transfer another table using dataset and writing ASP.NET code, tables are in different databases, and databases are in different servers. I wrote the following code, the second table is empty initially; public DataSet DS1;public DataSet DS2;public SqlDataAdapter DA2; private void Page_Load(object sender, System.EventArgs e){ // get dataset from database1 and display in gridSqlConnection conn1 = new SqlConnection("server=(local);database=;Uid=;password="); String strSQL1 = "select * from myTable1"; SqlDataAdapter DA1 = new SqlDataAdapter(strSQL1,conn1...

alter table of table A causes trigger on table B accesseng table A to fail
hi, i recently faced a strange problem, i have two tables, table A and table B table A has a update trigger which updates data in table B. i altered table B to add two more columns. after which when i updated table A(modifying 1 row), my tran log got full. there was a threshold proc which got fired but it did'nt help much. i though the tables had been corrupted. ran dbcc tablealloc on syslogs, table A, table B, no errors. Just to be sure I ran a dbcc checkdb, checkalloc and checkcatalog - no errors i recreated the trigger - no use. dropped the trigger. updated the table it ...

Help creating this table layout from 2 database tables
I'm having trouble working this through and hoping for a nudge in the right direction.  .Net 2.0 with C# codebehind  I need to create a reference table that has both the headers of the columns and a row identifier dynamically generated and then of course populate the table.  Example:     Midwest Southeast Northeast Job Title 1 John Smith Jane Doe Billy Bob Job Title 2 Some Name Employe Name Contact nameContact Name 2   The bold items are contained in a lookup...

How to transfer the table & its data from one database to another database
Hi I need to transfer the records & strcuture of the table from Database1 to Database2. It is like export/import functionality SQL server. Is there any way to do like this in ASA 8.0.2 B'cos most of the time i need to transfer some of the objects with data from one database to another. Please help me in this regard Thanks in advance Shankar Hi, I am doing this through a few ISQL statements e.g. (connected to db1) SELECT * FROM CUSTOMERS; OUTPUT TO "c:\\tmp\\customers.txt" FORMAT ASCII DELIMITED BY '\x09'; SELECT * FROM SUPPLIERS; OUTPUT...

Database table to formview to other table
Okay here's my situation I'm trying to make a page that the user is presented witha a single text box. This text box would be used to entering problems, complaints, etc. Apon Pressing insert there is a number of other fields that would be hidden that would be used to create a complete ticket to be written to a ticket database, this information would be pulled from a USer database using the User's login... Where I'm at... I currently am Using a Select statement for my User table, and an Insert Statement for my Tickets table. They are both in the same datasource and using Us...

Database tables and lookup up tables?
Ok say I would like to build a table for of the following questions(say 6 questions for the sake of argument): Do I just stored the index of the radiobuttonlist. What are some resources that I could look at. Should I make a look up table. 5) If money were no object, I would live . . . Prefer not to say On a tropical island In a New York penthouse In an English castle On a Texas ranch In a Malibu beach house In a mountain retreat (Selected) On the moon None of the above 1 ---> 2 ---> 3 ---> 4 ---> 5) --->6 ...

SQL call to count the total rows in Table B for each user in Table A
I have 2 tables:   TableA: Name UserA UserB UserC   Table B: Name               Data UserA              xxx UserB              asdasd UserB              ewrsad UserC              dsafasc UserA        &nbs...

need help designing a database table (or tables) to hold a hash ( %config) and ( %group)
Hi All i am creating a script for deployment of websites and i need to create hash %config ( which stores a lot of configurations setting for each type of website ) ... i have been manually eaditing this hash but now the hash has to now be generated from a a database ( mysql ) .... i have never worked with designing a database structure . Can any one guide me how to go about it . my hash structure looks some thing like this my %config = ( 'website_auto_1' => { 'group' => 'website_auto_group1', 'tempdir' => &#...

Web resources about - a little help with transfering table A in Database A into table B in database B - asp.net.sql-datasource

Helicopter Transfering Lineman to Wire - YouTube
Helicopter transfers linemen to the wire for energized insulator change-outs.

Nintendo details official process for transfering data to your New 3DS
Since the New 3DS is almost out, a lot of us are probably wondering how to copy over data from the old system both on-board data and save files ...

Terry Larrier is transfering to UConn
Terry Larrier, once a top 50 recruit, is leaving VCU to play for Kevin Ollie at UConn after just one season. The UConn Huskies went from National ...

Transfering magnetic fields across long distances
A Catalan, German and Austrian group of physicists has developed a new technology to transfer magnetic fields to arbitrary long distances, which ...

Fifa secretary general Jerome Valcke accused of transfering money central to bribe case
US prosecutors allege Sepp Blatter's deputy is connected to the bribery scandal engulfing football's governing body

User:Aeusoes1 - Wikipedia, the free encyclopedia
This is a Wiki pedia user page . This is not an encyclopedia article but maybe it should be one. If you find this page on any site other than ...

RealPlayer SuperPass - Premium Player with TV &amp Movies - 14-day Free Trial
FREE 14-day Trial RealPlayer SuperPass - Your trial of RealPlayer SuperPass is FREE. You can cancel anytime, or continue to enjoy all the features ...

Life of a Lab Rat
Dear Reader,this entry is a bit of a rant. I started writing about one thing, and finished up on a different road. But I think the final destination ...

myRTA
Back to Roads site Home About Contact us Online Tutorials Print this page Print this page Decrease Text Size Increase Text Size Change text size ...

On-Site PC Repair Specialists ** Techs-on-Call
Techs-on-Call is an on-site computer repair company. We come to you for all your computer services. Customer satisfaction is our priority.

Resources last updated: 12/25/2015 6:48:11 PM