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 |
|
JaybeeSQL
Posting Yak Master
112 Posts |
 Posted - 2013-10-01 : 10:17:11
|
| Hi all,I've imported an Access DB with a hundred tables or so that has no documentation/users, it is offline at the moment but I would like to set up a reporting platform with it. Oddly enough it has no FK's, considering there are quite a few join tables - I assume those constraints didn't survive the import process.I could continue to wade through the tables with the 20 greatest rowcounts, but does anyone know of a more efficient way of familiarising myself with what data is where and how it was all connected?Cheers,JB |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2013-10-01 : 10:47:32
|
| Can you look at the original access database to see if there are is anything there.Do you at least have indexes?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2013-10-01 : 11:58:13
|
| Hi Nige, no and no. |
|
|
|
|
|
|
Getting overview of new database