News, links, downloads, tips and tricks on Microsoft Access and related
Thursday, September 23, 2010
SQL Script Generator
Just found another SQL Script Generator instead of my favorite SQL Scripter, which is not free anymore. Works fine, and free. Do you have better suggestions?
Hi Alex. Somewhat related, I wrote a SQL Generator for Access which creates DDL scripts in either Access SQL, T-SQL, or as a stored procedure. It's also a free download here: RecreateTableInSQL.mdb
This is an old post, but you can give a try to https://fishcodelib.com/Database.htm I generally use it as a SSMS replacement, because it's a portable tool that does not require admin rights (I am a freelancer working mostly on client's site).
It can also connect to Access databases (and SQL Sever, Oracle, and many others) and the script generator included is quite fine.
Hi Alex. Somewhat related, I wrote a SQL Generator for Access which creates DDL scripts in either Access SQL, T-SQL, or as a stored procedure. It's also a free download here: RecreateTableInSQL.mdb
ReplyDeleteIt only works on tables and related indexes.
hi Alex,
ReplyDeleteThis is an old post, but you can give a try to https://fishcodelib.com/Database.htm
I generally use it as a SSMS replacement, because it's a portable tool that does not require admin rights (I am a freelancer working mostly on client's site).
It can also connect to Access databases (and SQL Sever, Oracle, and many others) and the script generator included is quite fine.