Exporting queries to MSSQL

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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting tables to .sql code 2
Export to XML - error 31532 0
Exporting Queries to Excel 1
Exporting queries for modification purpose and or backup 1
Export Data from Queries in Access 2007 to Excel Spreadsheet 1
Problem Exporting Query data to Word 2
How to Copy updated object design from test to live database 2
Exporting to dbase IV 1

Top