How do I convert an sql script into an executable .sql file? [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 11 years ago.

Improve this question

My manager asked me to to compile a set of sql scripts, I use some of those scripts for updating new records (some are used in ssms and ssis), to create table and scripts that I use to connect the foreign keys from the dim table to the fact table.

He asked me to do this... Can you send me the sql script used to prepare the initial environment? Please put that into a executable .sql file.

I haven't done this before and what tools should I use? SSMS? or SSIS? or Notepad?

I am using SQL Server, the tools I have is SSMS and BIDS

possible duplicate of Export database schema into SQL file

Dan Drews
– Dan Drews

2014-02-18 01:25:13 +00:00
Commented Feb 18, 2014 at 1:25 — Dan Drews
– Dan Drews, Commented Feb 18, 2014 at 1:25
What is your database server?

Geremy
– Geremy

2014-02-18 01:25:48 +00:00
Commented Feb 18, 2014 at 1:25 — Geremy
– Geremy, Commented Feb 18, 2014 at 1:25
Hi, Im using SQL Server

TheBA.BI.BO
– TheBA.BI.BO

2014-02-18 01:26:59 +00:00
Commented Feb 18, 2014 at 1:26 — TheBA.BI.BO
– TheBA.BI.BO, Commented Feb 18, 2014 at 1:26
A ".sql" file is just plain text containing the script.

Blorgbeard
– Blorgbeard

2014-02-18 01:27:49 +00:00
Commented Feb 18, 2014 at 1:27 — Blorgbeard
– Blorgbeard, Commented Feb 18, 2014 at 1:27
There is no such thing as an executable SQL file

Bohemian
– Bohemian ♦

2014-02-18 01:28:01 +00:00
Commented Feb 18, 2014 at 1:28 — Bohemian
– Bohemian ♦, Commented Feb 18, 2014 at 1:28

wruckie · Accepted Answer · 2014-02-18 03:23:51Z

1

In SSMS, write a sql statement and save. It will create a txt document with an .sql extension. 'Excuting' this file will, depending on your file associations, open SSMS and load this file. As for sending a sql script used to prepare the initial environment, there is no such thing. That is something that you will have to prepare; we know nothing about your environment.

I have created SQL scripts that contain many steps to help me run repetitive tasks. Run it once and all of my work is done, but I built them painstakingly by hand one-at-a-time screenshot

edited Feb 18, 2014 at 3:23

answered Feb 18, 2014 at 3:06

wruckie

1,8211 gold badge26 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bohemian · Accepted Answer · 2014-02-18 01:29:26Z

1

The is no such thing as an "executable" SQL file. There are just SQL files:

Try something like this:

rename myscript.txt myscript.sql

Or if you are using an editor:

Save: myscript.sql

answered Feb 18, 2014 at 1:29

Bohemian♦

427k103 gold badges603 silver badges750 bronze badges

1 Comment

Geremy Over a year ago

You are 'technically' write that there is no such thing as an 'executable' SQL file, but executable in this case may just mean verified "valid" or "working".

Collectives™ on Stack Overflow

How do I convert an sql script into an executable .sql file? [closed]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related