bfarr23
Right there with Babe
Points: 787
More actions
July 18, 2003 at 8:42 am
#159815
what is the best way to move data from one schema into a new/different schema?
Andy Warren
SSC Guru
Points: 119902
July 18, 2003 at 9:58 am
#466075
Depends on the complexity. If you can do it in pure TSQL, I'd go that way. Some moves may require more of a row based processing metaphor, DTS makes more sense there, or if moving from one platform (like Access or Excel).
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
OnlineHome
SSC Rookie
Points: 41
July 26, 2003 at 6:02 am
#467175
Hi,
i do this in T-SQL too, i use http://www.sqlscripter.com to script this code autom.
Regards.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply