Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davidshq
Posting Yak Master
119 Posts |
 Posted - 2007-01-15 : 22:56:08
|
| I had an ASP Link Directory. Recently I moved to an ASP.NET Link Directory. I used SSIS to import the Access database that the old link directory was based on into my new SQL Server 2005 database. Now I'm not sure where to go from here. I need to copy the contents of the old database into the new database structure. How would I go about doing this? For example:Old DatabaseTitle Description ParentCategoryNew DatabaseTitleName DescriptionContents Contributor ParentIDI need to make Title-->TitleName, Description-->DescriptionContents, and ParentCategory-->ParentID (skipping Contributor).David.- http://www.gamesecretary.com/- http://www.thehungersite.com/- http://www.grid.org/ |
|
|
|
|
|
Copying Data from One Table to Another.