arun_mrk Posted April 24, 2003 Posted April 24, 2003 I have sqlserver 2000, how should generate a sql server script file along with table data Quote
Moderators Robby Posted April 24, 2003 Moderators Posted April 24, 2003 Do you mean execute? Quote Visit...Bassic Software
arun_mrk Posted April 24, 2003 Author Posted April 24, 2003 no, i want to create a script file(.sql) Quote
Moderators Robby Posted April 24, 2003 Moderators Posted April 24, 2003 one more question... Using .Net code or in the designer? Quote Visit...Bassic Software
arun_mrk Posted April 24, 2003 Author Posted April 24, 2003 sql server(designer) is what i looking for? Never mind, ready to do either way if u could help me. Quote
Moderators Robby Posted April 24, 2003 Moderators Posted April 24, 2003 In SQL Server Enterprise Manager you can right-click on the object (table, Stored proc) and select All Tasks > Generate SQL Script. Quote Visit...Bassic Software
arun_mrk Posted April 25, 2003 Author Posted April 25, 2003 I'm very much aware of generating script file using sql server enterprise manager. What i want is along with the script the data(some default rows are entered) also have to appear in the script. How to do it? If u have had a look at microsoft ibuyspy they seem to have ibuyspy database script along with the data. Quote
arun_mrk Posted April 25, 2003 Author Posted April 25, 2003 correction to the above post I mean script file with 'Insert statement' as data. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.