Moving Data From One Table To Another

Nov 10, 2004

I imported a little over 9 million records into my database without "cleaning" the data.

I'm looking for suggestions on what would be the most efficient way to get all the fields to the correct types and to insert decimals on the fields that need them.


My only idea thus far is to make another table with the correct field types and append the data to the new table.

View 1 Replies


ADVERTISEMENT

Moving Data From One Table To Another

May 27, 1999

Hi all,

This is (probably) a simple question, but I'm new to SQL Server scripting.

What I want be able to do is move data from one table in a database to another table in the same database, once one of the fields (a date field) reaches a certain value.

Specifically, we are inserting rows into a table that are stamped with an insert date and an expiry date. When the expiry date is reached, we want to move the applicable row from the original table to an identically structured table.

Ideally, we want this to be a script that is run daily.

Does anyone have any ideas or examples that we could use.

Any help is much appreciated!



Tim

View 3 Replies View Related

Moving A Column Of Data To Different Table.

May 1, 2008

Hi,

Here is my scenario simplified.

tbl1
userid, secondaryid

tbl2
userID, secondaryID

tbl1 is already populated. I just want to transfer the secondary ID to tbl2 based on the userID. I don't want to store secondaryID in tbl1 anymore.

View 4 Replies View Related

Moving Data From One Table To Another Using Variables

Oct 20, 2013

I need to move data from one table to another using variable percentages and business days.

Here is the basic idea:

Variables: varTable1, varTable2, varPercentage

Get varPercentage of rows of VarTable1 that have a date of "current business date -1" and place into varTable2.

View 1 Replies View Related

Moving Data To A Table With A Different Field Structure

Sep 25, 2003

In order to export data to a 3rd party provider, I build five separate tables to store the data. Every table has a different layout, except for the first four columns. They are record type, SSN, employee id and another id number.

Basically, I have to sort that data by SSN then by record type. Each employee will have multiple records.

However, that data will need to be "merged" into one table to be exported.

I have created a table that defines the first four columns, but then has one large "filler" field that will contain the rest of the data. How can I copy data from five different tables with five different layouts into one table?

Any suggestions?

Thanks,
Steve Hanzelman

View 6 Replies View Related

??Moving Table With Data To Another Database In Sql Express 2005??

May 30, 2006

How to move some tables with data & procedures etc from 1 database to another in sql server 2005 express edition.
i did by scripting but i transfer tables and procedures and not data
data is the problem.
tnx

View 1 Replies View Related

Problem While Moving Data From Excel To Table Using SSIS

Jan 5, 2008

Hi,
I have an excel sheet in which there is some data in sheet1,sheet2.I need to transfer this 2 sheets data to single table using a single package.How can i do this in SSIS.


thanks in advance

Pradeep

View 4 Replies View Related

EM Transfer Manager Fails Moving Data After 80th Table?

Sep 14, 1999

Hello:

I am running on mssql 6.5, sp4. We have been trying to use EM transfer manager to move one test database on one server to another database on another server.
We are dealing with 135 tables on this database. The transfer works up until about the 80th atble and then just dies but the scheduled task says it failed and check error log. The transfer creates the tables on the destination database but only loads the data until this one table.

WE use all of the options in EM Transfer manager which are st as defaults.

THere is no one on the source or destination databases locking this table.

Other smaller databases were successfully transferred from one database on one server to the other database on the other server without any problems today and yesterday.

Has any one run across something like this?

THanks.

David Spaisman

View 1 Replies View Related

SQL Server 2012 :: Moving Identical Data From One Table To Another - Error On Converting To Float

Jun 11, 2014

So I have two tables with similar columns etc, unfortunately the Insert to the History table fails. Noto sure how to format.

Source Table.
CREATE TABLE [dbo].[SKUCURRENT](
[UID] [int] IDENTITY(1,1) NOT NULL,
[SKU] [nvarchar](100) NOT NULL,
[WHSELOC] [nvarchar](50) NOT NULL,
[WEIGHT] [nvarchar](50) NOT NULL,

[Code] ....

View 1 Replies View Related

Moving From One Table To Other Table Automatically For Every 3 Months By Checking The Paticular Value Of The Table Field

Mar 29, 2007

Hi
 
I am having a table called as status ,in that table one field is there i.e. currentstatus.
the rows which are having currentstatus as "ticket closed",i want to move those rows into  other table called repository which is having same table structure as status table.
I can do programatically.
but is there any way for every 3 months system has to check and do this action means moving to repository table automatically?
 
Please help me.
 
Thanks.

View 1 Replies View Related

Moving Lots Of Rows From Table To Another Table

Jan 17, 2008

Hi all,



I have two tables within the SQL server and there is an application writes 20.000 or 40000 rows in the First table.

1) I need to know when the table completes filled to start move the data to the second table.

2) After I copy the rows I need to delete the rows from the first table.



I though to use the trigger but I am not sure if this is the best approach or not





Please help....



Thank you

sms

View 11 Replies View Related

Moving From One Table To Another

Apr 6, 2007

I am trying to write a stored procedure that copies one row from one table and moves it to another table. The two tables do not have exactly the same number of columns and not all of the columns that are the same in each table have the same name. I am using MS SQL Server 2000 and I cannot figure out a way to do this.

My big question is how do you execute a query in a stored procedure and then use the results to execute an update in the same procedure. I want the entire function to occur without the client application having to do any of the work.

Thanks,
Julian

View 1 Replies View Related

Moving ONE Table To A Different Filegroup Using T-SQL

Aug 29, 2002

I need to know if it is possible to move ONE table from an existing filegroup to another existing filegroup.
The answer I received to use ALTER database only modifies the file/filegroup name or changes the default filegroup.
Any assistance will be greatly appreciated.

View 1 Replies View Related

Moving A Table To A Different Schema

Aug 27, 2012

We currently have all tables in the dbo schema, but for organizational reason we would like to split them up in multiple schemas and I wonder if that can be done without re-creating the tables.

So my question is, is there a way to move a table into a different schema without re-creating it? (For those familiar with Postgres I'm looking for an equivalent to "ALTER TABLE foo SET SCHEMA newschema") sp_rename only allows a "one-part name" for the new name, so apparently that cannot be used.

View 2 Replies View Related

Need Help Moving Dates From One Table To Another Using A DTS...

May 17, 2004

I have a timestamp in one table that is of datetime type and I need to move it to a table with a Varchar(30) type. What is happening is a date that should be set up like this "11/12/2004" is actually coming across as "Nov 12 2004". I tried using a cast(fieldname) as Varchar(30) on the datetime type, but it didn't help. does anyone have any ideas on how to retain the original date form in moving it to a varchar type? thanks in advance...

View 6 Replies View Related

Moving One Table Form One DB To Another

May 8, 2014

Wondering if its possible to copy a table form one DB and paste to another dB? is there a tool for that?

View 7 Replies View Related

Moving A Big Table To Another Server. Best Way?

Oct 23, 2007

I have a table with 200 million rows which needs to be moved to a different instance. What is the best way to move the table while at the same time getting rid of any unused space in the table? I think BCP is the fastest way to do this, but I am conrned that the results would be different than exporting the t-sql equivalent and running that.

Any comments? BOL does not appear to address this issue very clearly. . .

Thanks,

Michael

View 4 Replies View Related

Moving Rows Up And Down In A Table

Oct 19, 2007

Hi all,

I am currently writing a web service that gets data from a MSSQL2000 DB and I need to get the data to create some drop down lists, but these lists are composed of many concatenated elements. To sort these alphabetically is proving to be a royal pain in the butt as they just come out as they are ordered in the DB.

It would be a whole lot easier if i could just reorder the rows in one relevant table. Does anyone know how to do this or if it is possible to move rows up or down?

Thanks a lot!

Richee.

View 22 Replies View Related

Moving Data

Oct 23, 2007

 I have 2 databases on one server that I want to consolidate into one database. I'm just learning SQL Server 2005. What is the easiest way to move my 3 tables from one database to a new one on the same server? Do I have use SSIS to do it, or can a simple query be written? I'm new so please be a little detailed in your answer. Thanks in advance for any comments. 

View 2 Replies View Related

Moving Data Between 6.5 And 7

Aug 3, 2000

I have a scenario where I need to refresh a database that is in 7.0 (converted from 6.5 database) from the original database. Is there an easy way to do this. I have tried creating a DTS package but the data never seems to make it accross.

View 1 Replies View Related

Moving Data From 6.5 To 7.0

Feb 16, 1999

Hello,

I'm having problems using the update wizard to move data from 6.5 sql server
(on another machine) to a 7.0 server sitting out a PDC. The wizard dies (and
passes me over to Dr Watson) when login fails for the 6.5 machine.

I am sure I have the right pasword (I've tried variations as well) and have updated the
hosts file so that the machine is known by it's name (I think one of the FAQ answers
suggested that)....

What other possibilities are there for moving the data ? I looked at bcp, but that seems
a rather long winded route (the data contains time stamps so I suppose there will be
a problem reading them in on the 7.0 side) ...

Many Thanks,

Paul.

View 1 Replies View Related

Moving Data From One DB To Another

Sep 4, 1998

Hi all!
What is the best way to move selected data from one database to another using SQL 6.5?

View 1 Replies View Related

Moving Data

Sep 6, 2001

what would be the best way to move 59 million rows from one table to another. The table has no constraint, but has has three indexes. The table has only four columns. It will be going from SQL 2000 to SQL 2000.

Thank You

View 2 Replies View Related

Moving Record From View To A Table

Mar 28, 2006

Hi All,
I have a view that contains 30 million records.I want to move the view to a table in my database using DTS,but it is taking a lot of time,and making my tempdb to grow fast in giga bytes.Please is there anyway i can copy this view into the table easily in minutes.The view structure and the table structure are the same.Also, how can I index a view and can I add unique key to a view.

Thanks All in advance.
Mokah

View 6 Replies View Related

Moving Table To New File Group

Oct 17, 2007

Hi all

I have a table called ACTIVATION_CONSUMPTION which is in PRIMARY file group, in order to move this table to new file group [FG_ACTV], I have done the following

1. ALTER DATABASE [MYDB] ADD FILEGROUP [FG_ACTV] (i have not attached a file to this file group)

2. IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[ACTIVATION_CONSUMPTION]') AND name = N'ACTIVATION_CONSUMPTION_PK')
ALTER TABLE [dbo].[ACTIVATION_CONSUMPTION] DROP CONSTRAINT [ACTIVATION_CONSUMPTION_PK]
GO

3.ALTER TABLE [dbo].[ACTIVATION_CONSUMPTION] ADD CONSTRAINT [ACTIVATION_CONSUMPTION_PK] PRIMARY KEY CLUSTERED
(
[ACTIVATION_CONSUMPTION_ID] ASC
)WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [FG_ACTV]

The above command executed successfully and now the table is in new file group [FG_ACTV]

My question is how come the table was moved to new file group though it has no files attached to it?

Thanks in advance.

View 5 Replies View Related

Moving Table(s) To A Different Filegroup In SQL 2005

Oct 2, 2007

Is there anyway to move tables without any indexes to a filegroup?

View 1 Replies View Related

Moving Data From One Database To Another

Dec 5, 2006

Hi all,
I want to transfer all the data from one of my Ms Access tables to SQL Server table, using C#.
How can i do it?
Thanks in advance,
J.Jasmeeta.

View 6 Replies View Related

Moving Data From One Database To Another

Feb 2, 2007

Hi all,
                        I have an Ms Access table and a MsSql table. I am running a windows service in my localhost where the data from Ms access table will be copied to Ms sql table for every one minute. Before copying the data, the Ms sql table will be flushed inorder to avoid replicates.
                       Now i want to copy only the latest records updated within 1 min in Ms access table, to Ms sql table.
My Ms access table
Name        Id
jas            100
meena       101
viji             102
 
My Ms sql table
Name        Id
jas            100
meena       101
viji             102
 
After 1 min, say  2 records are added to my Ms access table like,
Name        Id
jas            100
meena       101
viji             102
bhuvana     103
pinky         104
Now i want to insert only the latest records from Ms access to Ms sql like,
Name        Id
jas            100
meena       101
viji             102
bhuvana     103
pinky         104
how to do this? thanx in advance.
Jasmeeta. 

View 4 Replies View Related

Moving Data Across Networks

Oct 10, 2007

I am wondering the best way to go about a task I have been assigned.  We have two similar websites but each is located on a different network.  One network is secure so it cannot be accessed on the normal WWW.  The secure network will contain the master database.  I need to write a program or do something with SQL server to retrieve all records from the WWW site and get them onto the secure database.  I also in the future will need to update records from the WWW site if they have been updated.  What is the easiest way to move data from one network to the other when I cannot connect to both databases simultaneously?
 Thanks,
Matt

View 5 Replies View Related

Moving Data Between Databases

Jan 5, 2006

I have a web app that has been regulated to a disconnected PC. It's runing IIS and 2.0 with sql server express, but no connectivity. I have changes that are made to some of the data in the db (data, bot schema). There is one particular table that I cannot overwrite, and must extract the data.
What methods are available to do this swap of data between databases? I was thinking of doing something like this:
Track last date that remote db was updated. Upload updated database into data directory, loop through records for all affected tables, any date that was past logged date then update the record if it exists or insert new record, and then loop through the remote db and delete this records that dont exist in the updated db.
This seems intensive and slow - especially as the tables get bigger but I can't think of another solution that can be done by a user using sometime of web interface.

View 1 Replies View Related

Moving Data From One Sql Server To Another

Jul 5, 2002

Our current sql server 7 is overloaded and I have been asked to move some data to a new box which is to be acquired. My query is as follows:

1what should be the ideal spec of a sql server to allow for windows 2000 in future. And how do I go about moving data from one to the other. I am new to sql and this is my first assignment.

Thanks

Eve

View 1 Replies View Related

Moving Data From One Sql Server To Another

Jul 5, 2002

Our current sql server 7 is overloaded and I have been asked to move some data to a new box which is to be acquired. My query is as follows:

1. What should be the ideal spec of a sql server to allow for windows 2000 in future.

2. Is there any kind of monitoring agent available to see how heavily loaded the server is and what load each application/database is creating.

3. And how do I go about moving data from one to the other.

4. What do I do at the clients end to ensure they are able to access their database.

I am new to sql and this is my first assignment.



Thanks

Eve

View 1 Replies View Related

MOVING DATA AND LOG FILE

May 25, 2001

I am trying to move a data and log backup file from my C drive to another drive to free my C drive. Does anybody know the easiest way to do it? Thanks.

View 6 Replies View Related







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