How to use sqlcmd to run my create database/tables/sp's script

Question

Post reply

How to use sqlcmd to run my create database/tables/sp's script

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

the are .NET references, and have nothing to do with having SQL installed or not.

you should be able to go to the project references and add them.

==edit whoops my bad...you do need it from SQL .==

redownload the project. I changed the project to copy that reference locally, and it now is included in the ..bin\Debug folder.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

niteshrajgopal SSCommitted Points: 1877 More actions · Answer 2

I dont have those references available to me for some reason:crying: will do some more research and get back to you

niteshrajgopal SSCommitted Points: 1877 More actions · Answer 3

Great. Thanks again. is the project attached to your previous post the updated one? Will let you know how I get along. You are a genius

niteshrajgopal SSCommitted Points: 1877 More actions · Answer 4

not to worry;-) I downloaded the SMO objects from here after quite a bit of searching:

http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

Will test the code today. Had a quick look and it looks great. This is the perfect solution to my problem. You have saved me alot of time and stress Lowell. Thank you very much. god bless:-D

Lowell SSC Guru Points: 323504 More actions · Answer 5

nite re-download the project one more time;

i tested it found some bugs and missing code, this versions much better.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

niteshrajgopal SSCommitted Points: 1877 More actions · Answer 6

niteshrajgopal

SSCommitted

Points: 1877

June 22, 2010 at 12:17 am

#1183091

awesome:Wow:. thank you. will do.

niteshrajgopal SSCommitted Points: 1877 More actions · Answer 7

Hey Lowell,

sorry to be a pain. I have a quick question. How do you deploy your application that uses this project?

Do you only display the connection form on the very first time the app is run or do you always display it everytime the user starts the app?

I'm thinking I should have a setting that specifies that the form to apply connection settings should be run only once. What do you think?

Lowell SSC Guru Points: 323504 More actions · Answer 8

well it really depends on your application.

if your application is a client-server kind of app, then changing the connection string would be once-at-startup, and then an on-demand situation, where the end user might switch from a test db to the live db.

You'd want to open the connection dialog if the saved connection info was invalid, but otherwise you'd build and use a connection that you had saved, right? that was one reason i have that "MySettings" feature in it.

if your application does nothing more than run a setup script, then you;d run the connection for every time it was executed, right? and maybe add logic to make sure they don't run in master or tempdb for example.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

niteshrajgopal SSCommitted Points: 1877 More actions · Answer 9

thanks again for the great advise. You program is a gem. it has saved me hours of research and development and it works so well;-)