I have a rather daunting task ahead of me. I have ot take an access mdb and bring it into sql express. Converting the tables is not a biggie, but I have more than 2500 queries that need to be brought over. I have several questions.
1. In many places I use queries with parameters as views. For example I might have a query that takes a couple of parameters and then turn around write another query that uses the first query as a table. Is there a way to do parameterized views in Sql?
2. Does anyone know of a decent automated tool to do this? The upsizing wizard is useless and I tried teh sql migration assistant, and it doesn't convert queries that have parameters.
3. Has anyone done anything on this kind of scale before?
Thanks ... Ed
1. The closest to parameterized views is using Table Valued Functions. Check in Books Online about using TVFs.
2. No 'decent tools' known. Parameterized views can be 'troublesome'.
3. Yes, and it will take a lot of dilligent and concentrated effort.
and 4. Good Luck -because you WILL need it!
