Timeline for Loop through tables or copy paste
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 7, 2015 at 7:56 | comment | added | Loïc Lopes | The ultimate source of records are the SQL Server tables created from SSMA. I must create new SQL server tables (in another database) which take each information from all the source tables. | |
| Oct 7, 2015 at 1:45 | comment | added | Travis Page | I think this falls into a scope of knowing your data unfortunately. Depending on the migration source to destination (OLTP vs OLAP) the strategy for normalization is going to vary. Also, the practice of master data management comes into play. Which record is the ultimate source of record? Both of these make it extremely challenging to offer a solution to the problem that someone else may be able to utilize. I hope I have given you at least some clarification. If so, based on the comments I will update my answer to reflect the thread here. | |
| Oct 6, 2015 at 8:16 | comment | added | Loïc Lopes | No, I want to know what would be the best practice to merge several tables in the same database which have some similar columns (but not all). Should I make a specific treatment for each table or should I put some effort into making something generic I can re use for each table? I hope it is more understandable. | |
| Oct 5, 2015 at 13:40 | comment | added | Travis Page | I think I need some clarification here. Are you trying to figure out if it is best when migrating multiple Access files to a single SQL Server database if you should take tables from your Access file that would be similar and combine them together to form a single larger table? For example, if you have File_A with Table_A and, File_B with Table_A1 does Table_A have a relationship with Table_A1? | |
| Oct 4, 2015 at 8:54 | comment | added | Loïc Lopes | I already use it, sorry for not explaining that. So my problem is if I should loop through the new SQL tables as I must merge them in one table or if I should have a specific treatment for each. | |
| Oct 2, 2015 at 20:04 | history | answered | Travis Page | CC BY-SA 3.0 |