Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to export old table values into new table Expand / Collapse
Author
Message
Posted Thursday, August 17, 2006 7:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 21, 2010 11:47 AM
Points: 2, Visits: 11
hi all,i need to export the old table values in to new table currently i am using sql server 2000... is it possible to do this....? 
Post #302337
Posted Thursday, August 17, 2006 12:48 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 4,064, Visits: 5,339

There are lots of ways to do it e.g. T-SQL, DTS.  Are the old and new tables in the same database?  Same server? 

Greg

 



Greg
Post #302439
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse