Exporting queries to MSSQL

  • Thread starter Thread starter BB
  • Start date Start date
B

BB

I am upgrading my Access DB to MSSQL. I would like to
export the queries (I already imported data from SQL, so I
don't need that). I tried Upsize Tool and that completely
failed - it couldn't even export the tables.

Is there a way to just export queries - they are pretty
hairy and I would rather not have to rewrite them.

Thanks,
BB
 
SQL Server doesn't really have the equivalent of Access queries. You might
be able to save some of the SELECT queries as views (although it depends on
what they're doing), or you might be able to use Stored Procedures to do the
equivalent. You can view the SQL for your queries, and see whether you can
just copy them into either a view or SP.
 
Back
Top