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 |
|
keentolearn
Starting Member
21 Posts |
 Posted - 2009-07-17 : 14:31:39
|
| Hi,I have many lists of data in excel to migrate to a database. I am using Microsoft SQL Server Management Studio. The structure of the database tables are different as it is an MVC (model view controller). So I have a Main table with MainIDs (created when data is added to the database), and many lookup tables (for picklist like Country, People, Office etc..) I need to update lookuptables first and then link each lookuptable to a MainLookUp table.I have imported the data from Excel into the database and created a table. This table contains data columns likeRecordID, Client, Country, Office, Description, Date, Team etc...apart from Description and Date fields, all the others are multiple values separated by semicolon. e.g. each RecordID only has one description and one date but can have many CLients, Offices, Team etc..There are lookuptables for these on the database with Values and LookUpIDs which link to the MainLookUpTable.It has already taken me too long to do the migration. I am writing mixture of insert statements, update queries and creating cursors (which I am not very experienced in). Can someone advise me the best way of creating a one big script for migration please?many many thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-17 : 14:36:39
|
| seems like what you need is to create a ssis pacakge which uses the comma seperated values, do the lookups on other tables based on this and retrives id value o be populated on target |
 |
|
|
|
|
|
|
|
Migrating data from Excel into an SQL database