RSS Text Data Mining: create

Showing posts with label create. Show all posts

Wednesday, March 28, 2012

Running a Stored procedure or a query

Hi Guys
I woud like to run either a stored procedure before runing the actual
report. The stored procedure will create and update a table and on the second
run the report query will run and produce the report.
Is it possible to achieve this?
Regards
Tofigh> I woud like to run either a stored procedure before runing the actual
> report. The stored procedure will create and update a table and on the
second
> run the report query will run and produce the report.
> Is it possible to achieve this?
I guess your report is scheduled. Just edit the scheduled job and insert a
step that executes the stored procedures before the step that causes the
report to run.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks for the reply, the report is not scheduled. the users will run the
report on demand.
Regards
Tofigh
"Dejan Sarka" wrote:
> > I woud like to run either a stored procedure before runing the actual
> > report. The stored procedure will create and update a table and on the
> second
> > run the report query will run and produce the report.
> >
> > Is it possible to achieve this?
> I guess your report is scheduled. Just edit the scheduled job and insert a
> step that executes the stored procedures before the step that causes the
> report to run.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||Then maybe you can use two SPs - one outer that is called from the report
and returns the data, and inside it you first make a call to the second
procedure that prepares the tables.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"TA" <TA@.discussions.microsoft.com> wrote in message
news:9C1789C5-6FF7-469B-888A-6B0E7547F2BA@.microsoft.com...
> Thanks for the reply, the report is not scheduled. the users will run the
> report on demand.
> Regards
> Tofigh
> "Dejan Sarka" wrote:
> > > I woud like to run either a stored procedure before runing the actual
> > > report. The stored procedure will create and update a table and on the
> > second
> > > run the report query will run and produce the report.
> > >
> > > Is it possible to achieve this?
> >
> > I guess your report is scheduled. Just edit the scheduled job and insert
a
> > step that executes the stored procedures before the step that causes the
> > report to run.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > www.SolidQualityLearning.com
> >
> >
> >

running a script to create a database in MSDE

I've been able to create a CD where it installs MSDE 2000
sp3 on a user machine. I need to create a database on the
users machine, how do I incorporate the SQL script to
create the database? Do I call the script within the
setup.ini file? Any sample anywhere I can take a look at?
Thank you,
Randers
hi Randers,
Randers wrote:
> I've been able to create a CD where it installs MSDE 2000
> sp3 on a user machine. I need to create a database on the
> users machine, how do I incorporate the SQL script to
> create the database? Do I call the script within the
> setup.ini file? Any sample anywhere I can take a look at?
> Thank you,
> Randers
unfortunately is not that easy as you are trying to do... nothing from the
box...
you can perhaps run oSql.exe to execute your DDL sql script, or a home built
app of yours you pass the path to your script and execute it via an
ADO/Ado.Net connection, or have a look at
http://msdn.microsoft.com/msdnmag/is...baseinstaller/ for
a custom made database installation task...
another approach is relying on tools such as
http://www.red-gate.com/sql/sql_packager.htm
or you could redistribute a full backup of your database made on your
distribution environment and, via osql.exe and/or a home built app of yours
relying on ADO/Ado.Net connection restore it on the destination instance...
the very same path could be performed using the .Mdf and .Ldf detached
database files and reattache them using sp_attach_db system stored
procedures...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Running a report to populate a cell

Hello,
I need to run several reports using the information in couple of cells of a
table as input parameters, and eventually create a report combining the
result from sub queries into one report.
In other words:
ColA ColB ColC ColD
9898 001 145
8789 000 454
I would like to run a query for every row using ColA and ColB as input
parameter and populate ColD accordingly
Is this possible in Reporting Services?I knew It was a bit cryptical ;)
I am not sure how to accomplish what you mentioned. The current report has
over 200 rows, would it be possible to create 400+ parameters and run
queries for each pair that way?
Here is a more detailed explanation of what I am trying to do
The data is about stock items in our inventory
so each line lists a stock item and some info on it like where it sits, how
many do we have etc.
For each line I need to run a query to get me how many we shipped last year.
then I will extend this and run a query for each item to get setup costs
etc.
the end result will be one table with all the detailed information, the
intend is to generate a formula to determine safety stock levels and reorder
quantities electronically
Thanks
"Skeptical" <skep@.yahoo.com> wrote in message
news:%23gnfkdveEHA.3028@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I need to run several reports using the information in couple of cells of
a
> table as input parameters, and eventually create a report combining the
> result from sub queries into one report.
> In other words:
> ColA ColB ColC ColD
> 9898 001 145
> 8789 000 454
>
> I would like to run a query for every row using ColA and ColB as input
> parameter and populate ColD accordingly
> Is this possible in Reporting Services?
>|||Take a look at the sample reports that come with SRS... the product catalog
example sounds a lot like what you're looking for.
Rather than creat 400+ parameters in a single report, the reports are broken
down by subject matter and detail level. Then, via initiating actions (see
SRS books online) a row value is presented as a hyperlink. When the user
clicks the link, it passes the value as a parameter to another report which
is generated. Although it is another report, it appears to the user as the
same report/site.
Good luck!
X
"Skeptical" wrote:
> I knew It was a bit cryptical ;)
> I am not sure how to accomplish what you mentioned. The current report has
> over 200 rows, would it be possible to create 400+ parameters and run
> queries for each pair that way?
> Here is a more detailed explanation of what I am trying to do
> The data is about stock items in our inventory
> so each line lists a stock item and some info on it like where it sits, how
> many do we have etc.
> For each line I need to run a query to get me how many we shipped last year.
> then I will extend this and run a query for each item to get setup costs
> etc.
> the end result will be one table with all the detailed information, the
> intend is to generate a formula to determine safety stock levels and reorder
> quantities electronically
> Thanks
>
>
> "Skeptical" <skep@.yahoo.com> wrote in message
> news:%23gnfkdveEHA.3028@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I need to run several reports using the information in couple of cells of
> a
> > table as input parameters, and eventually create a report combining the
> > result from sub queries into one report.
> >
> > In other words:
> >
> > ColA ColB ColC ColD
> > 9898 001 145
> > 8789 000 454
> >
> >
> > I would like to run a query for every row using ColA and ColB as input
> > parameter and populate ColD accordingly
> >
> > Is this possible in Reporting Services?
> >
> >
>
>|||Thanks,
Well does it store the new value in the cell or does it calculate it once
the user clicks on the cell? I think I found a way of easily doing it rather
than going through all the cells.
I run the first one and store it in a temp table then I run the second and
store it in a temp table and left outer join them into one master table.
I do not know if Reporting Services would let me play with temp tables yet,
but if it could I am almost done.
I have never seen those example reports, sounds like they worth a look.
Thanks again for your input
"Xfonhe" <Xfonhe@.discussions.microsoft.com> wrote in message
news:E9C07F89-F7A6-46D8-ACE8-00390DB859B3@.microsoft.com...
> Take a look at the sample reports that come with SRS... the product
catalog
> example sounds a lot like what you're looking for.
> Rather than creat 400+ parameters in a single report, the reports are
broken
> down by subject matter and detail level. Then, via initiating actions (see
> SRS books online) a row value is presented as a hyperlink. When the user
> clicks the link, it passes the value as a parameter to another report
which
> is generated. Although it is another report, it appears to the user as the
> same report/site.
> Good luck!
> X
>
> "Skeptical" wrote:
> > I knew It was a bit cryptical ;)
> >
> > I am not sure how to accomplish what you mentioned. The current report
has
> > over 200 rows, would it be possible to create 400+ parameters and run
> > queries for each pair that way?
> >
> > Here is a more detailed explanation of what I am trying to do
> >
> > The data is about stock items in our inventory
> >
> > so each line lists a stock item and some info on it like where it sits,
how
> > many do we have etc.
> >
> > For each line I need to run a query to get me how many we shipped last
year.
> > then I will extend this and run a query for each item to get setup costs
> > etc.
> >
> > the end result will be one table with all the detailed information, the
> > intend is to generate a formula to determine safety stock levels and
reorder
> > quantities electronically
> >
> > Thanks
> >
> >
> >
> >
> > "Skeptical" <skep@.yahoo.com> wrote in message
> > news:%23gnfkdveEHA.3028@.TK2MSFTNGP12.phx.gbl...
> > > Hello,
> > >
> > > I need to run several reports using the information in couple of cells
of
> > a
> > > table as input parameters, and eventually create a report combining
the
> > > result from sub queries into one report.
> > >
> > > In other words:
> > >
> > > ColA ColB ColC ColD
> > > 9898 001 145
> > > 8789 000 454
> > >
> > >
> > > I would like to run a query for every row using ColA and ColB as
input
> > > parameter and populate ColD accordingly
> > >
> > > Is this possible in Reporting Services?
> > >
> > >
> >
> >
> >

Friday, March 23, 2012

Running 2005 SSIS Jobs on 2000

I would like to create an SSIS package in 2005 and run it in 2000. Is there anyway to do this? Or does SQL Server 2000 have a precursor to SSIS? I am trying to create a job to automatically catch and kill orphaned processes.
-Kyle
DTS is the product you will need to use in SQL Server 2000.

Running 2005 AS on 2000 DB, or should I upgrade 2000 Server to 2005?

I have searched a bit and read some threads, but want to clarify

I want to create Data Mart/Warehouse to use with SQL 2005 Analysis service

Questions:
Is there any problem using SQL 2000 Database as backend?We do plan to upgrade to SQL 2005, will there be problem in migrating the analysis service?Can I run 2005 AS stuff on SQL 2000 database? like creating cube, data mining model?I want to run Predictive Model/Data Mining Model on it as well, do they work on 2000 DB?I guess in short
Should I upgrade the server to 2005 before I start playing with 2005 AS?Can I start with 2005 AS on 2000 DB, then upgrade 2000 DB to 2005 whenever?
Thanks, any help is appreciated greatly

Is there any problem using SQL 2000 Database as backend?

RunCommands problem in Setup.lst

Im trying to create a setup cd using office setup wizard. I want the setup to
install my MSDE SP3 at the end of the installation. So I've placed the
following command in the setup.lst under [RunCommands]
MSDERelA\setup.exe InstanceName="TaShel" SAPWD "sa" SecurityMode="SQL
MSDERelA is a folder on my setup cd containing the MSDE files.
I can use the same command to run it from the command prompt but the command
is not running during the setup process.
If anyone could shed some light on this problem of mine.
Thanks
Dorji
hi Dorji,
Dorji wrote:
> Im trying to create a setup cd using office setup wizard. I want the
> setup to install my MSDE SP3 at the end of the installation. So I've
> placed the following command in the setup.lst under [RunCommands]
I'm not prepared about office setup wizard... try asking in the Office ng
hyerarchy...
BTW...
MSDERelA\setup.exe InstanceName="TaShel" SAPWD "sa" SecurityMode="SQL
=
MSDERelA\setup.exe InstanceName="TaShel" SAPWD="sa" SecurityMode=SQL
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Wednesday, March 21, 2012

Run Time parameter query

Why is it that I can create a parameter query in Enterprise Manager but
cannot repeat this in query analyser? How could I create a run time parameter
query (in my parlance a query that allows users to input values)!?
Thanks
SamOn Tue, 18 Jan 2005 03:29:03 -0800, Sam wrote:
>Why is it that I can create a parameter query in Enterprise Manager but
>cannot repeat this in query analyser? How could I create a run time parameter
>query (in my parlance a query that allows users to input values)!?
>Thanks
>Sam
Hi Sam,
This can't be done. Interaction with the end user (like asking for a
parameter) must be handled by the client application.
EM apparently has some support for asking parameter values. QA doesn't.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||SQL Server is a back-end server. It cannot ask a user for any parameters since SQL Server runs only
on the server. Possibly EM has some facility to ask for a parameter value, but that would be a
feature in EM. In SQL Server, you typically use stored procedures, where a stored procedure can take
a number of parameters, where the parameters are used inside the query or queries inside the
procedure.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:3755656C-5C1E-4AB5-9018-68B80F3FA855@.microsoft.com...
> Why is it that I can create a parameter query in Enterprise Manager but
> cannot repeat this in query analyser? How could I create a run time parameter
> query (in my parlance a query that allows users to input values)!?
> Thanks
> Sam
>sql

Run Time parameter query

Why is it that I can create a parameter query in Enterprise Manager but
cannot repeat this in query analyser? How could I create a run time parameter
query (in my parlance a query that allows users to input values)!?
Thanks
Sam
On Tue, 18 Jan 2005 03:29:03 -0800, Sam wrote:

>Why is it that I can create a parameter query in Enterprise Manager but
>cannot repeat this in query analyser? How could I create a run time parameter
>query (in my parlance a query that allows users to input values)!?
>Thanks
>Sam
Hi Sam,
This can't be done. Interaction with the end user (like asking for a
parameter) must be handled by the client application.
EM apparently has some support for asking parameter values. QA doesn't.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||SQL Server is a back-end server. It cannot ask a user for any parameters since SQL Server runs only
on the server. Possibly EM has some facility to ask for a parameter value, but that would be a
feature in EM. In SQL Server, you typically use stored procedures, where a stored procedure can take
a number of parameters, where the parameters are used inside the query or queries inside the
procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:3755656C-5C1E-4AB5-9018-68B80F3FA855@.microsoft.com...
> Why is it that I can create a parameter query in Enterprise Manager but
> cannot repeat this in query analyser? How could I create a run time parameter
> query (in my parlance a query that allows users to input values)!?
> Thanks
> Sam
>

Run Time parameter query

Why is it that I can create a parameter query in Enterprise Manager but
cannot repeat this in query analyser? How could I create a run time paramete
r
query (in my parlance a query that allows users to input values)!?
Thanks
SamOn Tue, 18 Jan 2005 03:29:03 -0800, Sam wrote:

>Why is it that I can create a parameter query in Enterprise Manager but
>cannot repeat this in query analyser? How could I create a run time paramet
er
>query (in my parlance a query that allows users to input values)!?
>Thanks
>Sam
Hi Sam,
This can't be done. Interaction with the end user (like asking for a
parameter) must be handled by the client application.
EM apparently has some support for asking parameter values. QA doesn't.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||SQL Server is a back-end server. It cannot ask a user for any parameters sin
ce SQL Server runs only
on the server. Possibly EM has some facility to ask for a parameter value, b
ut that would be a
feature in EM. In SQL Server, you typically use stored procedures, where a s
tored procedure can take
a number of parameters, where the parameters are used inside the query or qu
eries inside the
procedure.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:3755656C-5C1E-4AB5-9018-68B80F3FA855@.microsoft.com...
> Why is it that I can create a parameter query in Enterprise Manager but
> cannot repeat this in query analyser? How could I create a run time parame
ter
> query (in my parlance a query that allows users to input values)!?
> Thanks
> Sam
>

run time error

I create an application with Visual Basic 6 and Crystal Report 10
with IDE Environment.While Developing the application it works fine
in my system.but after i made the application
setup, and when while I am deploying (install)the application
in the same system (widows xp) it show run time error. i ignore the
error and continue the installiation till the end.
and then when i run the application it works ok but when i use print
command it show error(crviewer file not found). and the application
closed.so what is the problem here.please help
to solve it.

thanksEither you have not included the crviewer.dll file in your setup package or there might have been a problem while copying/registering the file. Try registering the File manually using regsvr32.

Run SQL-Server Query in Excel

Hi guys,
is there a way to run a SQL-query on a SQL-Server
within Excel?
(Is it possible to create any JOIN-querys and DATEDIFF-functions within
Excel-Microsoft Query?)
Thanks much guys,
Mike
Yes, is possible.
1. Start to record Macro.
2. Data > Import External Data > New Database Query .. > ...... > and so
on ..(Build a simple query and rerturn data to Excel)
3. Stop record Macro and Edit . You can change your query and run Macro
whenever you want.
"Maik Richter" <maik.richter2@.gmx.de> wrote in message
news:%23XeAJjvcEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi guys,
> is there a way to run a SQL-query on a SQL-Server
> within Excel?
> (Is it possible to create any JOIN-querys and DATEDIFF-functions within
> Excel-Microsoft Query?)
> Thanks much guys,
> Mike
>

Run SQL-Server Query in Excel

Hi guys,
is there a way to run a SQL-query on a SQL-Server
within Excel?
(Is it possible to create any JOIN-querys and DATEDIFF-functions within
Excel-Microsoft Query?)
Thanks much guys,
MikeYes, is possible.
1. Start to record Macro.
2. Data > Import External Data > New Database Query .. > ...... > and so
on ..(Build a simple query and rerturn data to Excel)
3. Stop record Macro and Edit . You can change your query and run Macro
whenever you want.
"Maik Richter" <maik.richter2@.gmx.de> wrote in message
news:%23XeAJjvcEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi guys,
> is there a way to run a SQL-query on a SQL-Server
> within Excel?
> (Is it possible to create any JOIN-querys and DATEDIFF-functions within
> Excel-Microsoft Query?)
> Thanks much guys,
> Mike
>

Run Sql Stored Procedure From Excel

I want to create a Stored Procedure in SQL with three variables that are declared in an Excel file.

Thus, when the user enters the three variables into

Cells A1, B1, C1

Then hits a button...

The Stored procedure in SQL 2000 will run - and then return the results to a refreshable pivot table in the Excel file.

Any ideas?

Quote:

Originally Posted by flickimp

I want to create a Stored Procedure in SQL with three variables that are declared in an Excel file.

Thus, when the user enters the three variables into

Cells A1, B1, C1

Then hits a button...

The Stored procedure in SQL 2000 will run - and then return the results to a refreshable pivot table in the Excel file.

Any ideas?

Write an Excel Macro for this.
Connect to SQL Server from Excel and call a procedure as required.|||New to macros.

Any tips?|||

Quote:

Originally Posted by flickimp

New to macros.

Any tips?

You can find lots of examples by little web searching.
Kindly POST what you tried so that we could help in case of any problem!!|||Hi

Heres the Stored Procedure

Say in Excel -- cell A1 = @.Type and cell B1 = @.LSS

Create Proc sp_Flickimp_test
@.TypeVarchar(3),
@.LSSVarchar(3)
as
SelectProvider_Code,
Commissioner_Code,
LSS_Flag,
Financial_Year,
Financial_Month,
Specialty_Code,
Description_Contract,
Activity_Type,
CaseWhen Activity_Type in ('Emergency','Non-elective') Then 'Non-Elective'
Else Activity_Type End as Activity_Type_Grouped,
HRG_Code,
Specialised_Services_Code,
Local_AdmitUnit_Code,
Total_Spells, Tariff_Initial_Amount, Tariff_ShortStay_Spells,
Tariff_ShortStay_Adj, Tariff_SpecServ_Adj, Tariff_Final_Amount,
Tariff_LS_Spells, Tariff_LS_Days, Tariff_LS_Rate, Tariff_LS_Payment,
Tariff_Total_Payment, Local_Total_Payment, Local_AdmitUnit_Adj

Fromtbl_BaseLine_UHL_Spells_Trend_0708 a

LeftOuter Join dbo.tbl_Refs_Specialty_UHL b
on a.Specialty_Code = b.Code

LeftOuter Join dbo.tbl_Refs_IP_SpecServ_0708 c
on a.Specialised_Services_Code = c.SpecServ

Where(Financial_year = '2006/07' and Financial_Month between '7' and '12')
or(Financial_year = '2007/08' and Financial_Month between '1' and '6')
andCommissioner_Code = @.Type
andLSS_Flag = @.LSS|||As a full member now, you should know that we expect your code to be posted in [CODE] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use the tags in future.

MODERATOR|||

Quote:

Originally Posted by flickimp

Heres the Stored Procedure

Say in Excel -- cell A1 = @.Type and cell B1 = @.LSS

Fromtbl_BaseLine_UHL_Spells_Trend_0708 a

LeftOuter Join dbo.tbl_Refs_Specialty_UHL b
on a.Specialty_Code = b.Code

LeftOuter Join dbo.tbl_Refs_IP_SpecServ_0708 c
on a.Specialised_Services_Code = c.SpecServ

Where(Financial_year = '2006/07' and Financial_Month between '7' and '12')
or(Financial_year = '2007/08' and Financial_Month between '1' and '6')
andCommissioner_Code = @.Type
andLSS_Flag = @.LSS

Alright!! Did you try calling this from a Macro.
You need to connect to SQL server from Excel.|||Hi

Sorry for not using the tags.

The Stored procedure was created in SQL Query Analyzer 2000.

I tried to use MS Query to pull the SP back with the variables, but no joy.

What steps must I take to allow the parameters from excel cells to be picked up by the stored procedure so that it returns the results back to excel?

run sql script on sql server2000

dear all i am using ASP.net ,c# and SQL server 2000. i have create all
table, stored procedure .views in my application which is running well
in localhost but now i want to deploy it on server. for that pupose i
need to create all table, stored procedure, views on the domain server
database. can any one tell me how i can do it?Do you have the DDL in script files? Or do you just want to transfer the database on your local
database as is to the server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> table, stored procedure .views in my application which is running well
> in localhost but now i want to deploy it on server. for that pupose i
> need to create all table, stored procedure, views on the domain server
> database. can any one tell me how i can do it?
>|||Hi,
Easy option is :-
1. Backup the database in your machine [Use Backup Database]
2. Copy the backup file to Domain server
3. Restore the database [Use Restore Database command]
4. If you do not want the data then Truncate the contents of all tables.
follow the parent chld relationship
while truncating table.
Alternative is ... In the local sql server .. open enterprise manager..
Select database .. right click-- all tasks-- Generate SQL Scripts...
choose all objects , all dependant objects -- permissions...Script it as a
SQL file. Then you could use this script to create
objects in Domain sql server.
Thanks
Hari
SQL Server MVP
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> table, stored procedure .views in my application which is running well
> in localhost but now i want to deploy it on server. for that pupose i
> is
> need to create all table, stored procedure, views on the domain server
> database. can any one tell me how i can do it?
>|||but i am not having access of enterprise manager of domain server. i
need to run it only programatically.
Hari Prasad wrote:
> Hi,
> Easy option is :-
> 1. Backup the database in your machine [Use Backup Database]
> 2. Copy the backup file to Domain server
> 3. Restore the database [Use Restore Database command]
> 4. If you do not want the data then Truncate the contents of all tables.
> follow the parent chld relationship
> while truncating table.
> Alternative is ... In the local sql server .. open enterprise manager..
> Select database .. right click-- all tasks-- Generate SQL Scripts...
> choose all objects , all dependant objects -- permissions...Script it as a
> SQL file. Then you could use this script to create
> objects in Domain sql server.
>
> Thanks
> Hari
> SQL Server MVP
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >
> > table, stored procedure .views in my application which is running well
> > in localhost but now i want to deploy it on server. for that pupose i
> > is
> > need to create all table, stored procedure, views on the domain server
> >
> > database. can any one tell me how i can do it?
> >|||> but i am not having access of enterprise manager of domain server. i
> need to run it only programatically.
From what programming language?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> but i am not having access of enterprise manager of domain server. i
> need to run it only programatically.
> Hari Prasad wrote:
>> Hi,
>> Easy option is :-
>> 1. Backup the database in your machine [Use Backup Database]
>> 2. Copy the backup file to Domain server
>> 3. Restore the database [Use Restore Database command]
>> 4. If you do not want the data then Truncate the contents of all tables.
>> follow the parent chld relationship
>> while truncating table.
>> Alternative is ... In the local sql server .. open enterprise manager..
>> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> choose all objects , all dependant objects -- permissions...Script it as a
>> SQL file. Then you could use this script to create
>> objects in Domain sql server.
>>
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >
>> > table, stored procedure .views in my application which is running well
>> > in localhost but now i want to deploy it on server. for that pupose i
>> > is
>> > need to create all table, stored procedure, views on the domain server
>> >
>> > database. can any one tell me how i can do it?
>> >
>|||In asp.net using C#.net
Tibor Karaszi wrote:
> > but i am not having access of enterprise manager of domain server. i
> > need to run it only programatically.
> From what programming language?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> > but i am not having access of enterprise manager of domain server. i
> > need to run it only programatically.
> > Hari Prasad wrote:
> >> Hi,
> >>
> >> Easy option is :-
> >>
> >> 1. Backup the database in your machine [Use Backup Database]
> >> 2. Copy the backup file to Domain server
> >> 3. Restore the database [Use Restore Database command]
> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> follow the parent chld relationship
> >> while truncating table.
> >>
> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> SQL file. Then you could use this script to create
> >> objects in Domain sql server.
> >>
> >>
> >> Thanks
> >> Hari
> >> SQL Server MVP
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >
> >> > table, stored procedure .views in my application which is running well
> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> > is
> >> > need to create all table, stored procedure, views on the domain server
> >> >
> >> > database. can any one tell me how i can do it?
> >> >
> >|||Read the file from your code, take the SQL from the file you read and put it in a command object.
Whenever you reach GO in the script file, execute what you have in the command object using
ExecuteNonQuery.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> In asp.net using C#.net
> Tibor Karaszi wrote:
>> > but i am not having access of enterprise manager of domain server. i
>> > need to run it only programatically.
>> From what programming language?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> > but i am not having access of enterprise manager of domain server. i
>> > need to run it only programatically.
>> > Hari Prasad wrote:
>> >> Hi,
>> >>
>> >> Easy option is :-
>> >>
>> >> 1. Backup the database in your machine [Use Backup Database]
>> >> 2. Copy the backup file to Domain server
>> >> 3. Restore the database [Use Restore Database command]
>> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> follow the parent chld relationship
>> >> while truncating table.
>> >>
>> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> SQL file. Then you could use this script to create
>> >> objects in Domain sql server.
>> >>
>> >>
>> >> Thanks
>> >> Hari
>> >> SQL Server MVP
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >
>> >> > table, stored procedure .views in my application which is running well
>> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> > is
>> >> > need to create all table, stored procedure, views on the domain server
>> >> >
>> >> > database. can any one tell me how i can do it?
>> >> >
>> >
>|||ok fine it is working but how i can transfer data from local to domain
server.
--
Tibor Karaszi wrote:
> Read the file from your code, take the SQL from the file you read and put it in a command object.
> Whenever you reach GO in the script file, execute what you have in the command object using
> ExecuteNonQuery.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> > In asp.net using C#.net
> >
> > Tibor Karaszi wrote:
> >> > but i am not having access of enterprise manager of domain server. i
> >> > need to run it only programatically.
> >>
> >> From what programming language?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> > but i am not having access of enterprise manager of domain server. i
> >> > need to run it only programatically.
> >> > Hari Prasad wrote:
> >> >> Hi,
> >> >>
> >> >> Easy option is :-
> >> >>
> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> 2. Copy the backup file to Domain server
> >> >> 3. Restore the database [Use Restore Database command]
> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> follow the parent chld relationship
> >> >> while truncating table.
> >> >>
> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> SQL file. Then you could use this script to create
> >> >> objects in Domain sql server.
> >> >>
> >> >>
> >> >> Thanks
> >> >> Hari
> >> >> SQL Server MVP
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >
> >> >> > table, stored procedure .views in my application which is running well
> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> > is
> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >
> >> >> > database. can any one tell me how i can do it?
> >> >> >
> >> >
> >|||I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
Servers?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> ok fine it is working but how i can transfer data from local to domain
> server.
> --
> Tibor Karaszi wrote:
>> Read the file from your code, take the SQL from the file you read and put it in a command object.
>> Whenever you reach GO in the script file, execute what you have in the command object using
>> ExecuteNonQuery.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> > In asp.net using C#.net
>> >
>> > Tibor Karaszi wrote:
>> >> > but i am not having access of enterprise manager of domain server. i
>> >> > need to run it only programatically.
>> >>
>> >> From what programming language?
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> > but i am not having access of enterprise manager of domain server. i
>> >> > need to run it only programatically.
>> >> > Hari Prasad wrote:
>> >> >> Hi,
>> >> >>
>> >> >> Easy option is :-
>> >> >>
>> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> 2. Copy the backup file to Domain server
>> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> follow the parent chld relationship
>> >> >> while truncating table.
>> >> >>
>> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> SQL file. Then you could use this script to create
>> >> >> objects in Domain sql server.
>> >> >>
>> >> >>
>> >> >> Thanks
>> >> >> Hari
>> >> >> SQL Server MVP
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >
>> >> >> > table, stored procedure .views in my application which is running well
>> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> > is
>> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >
>> >> >> > database. can any one tell me how i can do it?
>> >> >> >
>> >> >
>> >
>|||i am having data at my local sql server but i need to transfer it on
domain sql server. but i don't have direct access of domain enterprise
manager or query analyzer i am having only DSN Name uid and pwd.
Tibor Karaszi wrote:
> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
> Servers?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> > ok fine it is working but how i can transfer data from local to domain
> > server.
> >
> > --
> > Tibor Karaszi wrote:
> >> Read the file from your code, take the SQL from the file you read and put it in a command object.
> >> Whenever you reach GO in the script file, execute what you have in the command object using
> >> ExecuteNonQuery.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> >> > In asp.net using C#.net
> >> >
> >> > Tibor Karaszi wrote:
> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> > need to run it only programatically.
> >> >>
> >> >> From what programming language?
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> > need to run it only programatically.
> >> >> > Hari Prasad wrote:
> >> >> >> Hi,
> >> >> >>
> >> >> >> Easy option is :-
> >> >> >>
> >> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> >> 2. Copy the backup file to Domain server
> >> >> >> 3. Restore the database [Use Restore Database command]
> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> >> follow the parent chld relationship
> >> >> >> while truncating table.
> >> >> >>
> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> >> SQL file. Then you could use this script to create
> >> >> >> objects in Domain sql server.
> >> >> >>
> >> >> >>
> >> >> >> Thanks
> >> >> >> Hari
> >> >> >> SQL Server MVP
> >> >> >>
> >> >> >>
> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >> >
> >> >> >> > table, stored procedure .views in my application which is running well
> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> >> > is
> >> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >> >
> >> >> >> > database. can any one tell me how i can do it?
> >> >> >> >
> >> >> >
> >> >
> >|||Let me see if I understand this.
You have a local SQL Server with schema and data. You have script files for the DDL on your local
SQL Server.
You now want to get both the schema and data to the other SQL Server.
I'm confused by the comment:
> but i don't have direct access of domain enterprise
> manager or query analyzer i am having only DSN Name uid and pwd.
If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager, right?
Anyhow, why not transfer the whole database using backup and restore? If you do want to script out
the data as well as the DDL, check out some options at:
http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
>i am having data at my local sql server but i need to transfer it on
> domain sql server. but i don't have direct access of domain enterprise
> manager or query analyzer i am having only DSN Name uid and pwd.
>
> Tibor Karaszi wrote:
>> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
>> Servers?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
>> > ok fine it is working but how i can transfer data from local to domain
>> > server.
>> >
>> > --
>> > Tibor Karaszi wrote:
>> >> Read the file from your code, take the SQL from the file you read and put it in a command
>> >> object.
>> >> Whenever you reach GO in the script file, execute what you have in the command object using
>> >> ExecuteNonQuery.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> >> > In asp.net using C#.net
>> >> >
>> >> > Tibor Karaszi wrote:
>> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> > need to run it only programatically.
>> >> >>
>> >> >> From what programming language?
>> >> >>
>> >> >> --
>> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> http://www.solidqualitylearning.com/
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> > need to run it only programatically.
>> >> >> > Hari Prasad wrote:
>> >> >> >> Hi,
>> >> >> >>
>> >> >> >> Easy option is :-
>> >> >> >>
>> >> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> >> 2. Copy the backup file to Domain server
>> >> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> >> follow the parent chld relationship
>> >> >> >> while truncating table.
>> >> >> >>
>> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> >> SQL file. Then you could use this script to create
>> >> >> >> objects in Domain sql server.
>> >> >> >>
>> >> >> >>
>> >> >> >> Thanks
>> >> >> >> Hari
>> >> >> >> SQL Server MVP
>> >> >> >>
>> >> >> >>
>> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >> >
>> >> >> >> > table, stored procedure .views in my application which is running well
>> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> >> > is
>> >> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >> >
>> >> >> >> > database. can any one tell me how i can do it?
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>|||i want to say i don't have access of domain servers sql server
enterprise manager and query analyser which i have registered
Tibor Karaszi wrote:
> Let me see if I understand this.
> You have a local SQL Server with schema and data. You have script files for the DDL on your local
> SQL Server.
> You now want to get both the schema and data to the other SQL Server.
> I'm confused by the comment:
> > but i don't have direct access of domain enterprise
> > manager or query analyzer i am having only DSN Name uid and pwd.
> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager, right?
> Anyhow, why not transfer the whole database using backup and restore? If you do want to script out
> the data as well as the DDL, check out some options at:
> http://www.karaszi.com/SQLServer/info_generate_script.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
> >i am having data at my local sql server but i need to transfer it on
> > domain sql server. but i don't have direct access of domain enterprise
> > manager or query analyzer i am having only DSN Name uid and pwd.
> >
> >
> > Tibor Karaszi wrote:
> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
> >> Servers?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> >> > ok fine it is working but how i can transfer data from local to domain
> >> > server.
> >> >
> >> > --
> >> > Tibor Karaszi wrote:
> >> >> Read the file from your code, take the SQL from the file you read and put it in a command
> >> >> object.
> >> >> Whenever you reach GO in the script file, execute what you have in the command object using
> >> >> ExecuteNonQuery.
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> >> >> > In asp.net using C#.net
> >> >> >
> >> >> > Tibor Karaszi wrote:
> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> > need to run it only programatically.
> >> >> >>
> >> >> >> From what programming language?
> >> >> >>
> >> >> >> --
> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> http://www.solidqualitylearning.com/
> >> >> >>
> >> >> >>
> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> > need to run it only programatically.
> >> >> >> > Hari Prasad wrote:
> >> >> >> >> Hi,
> >> >> >> >>
> >> >> >> >> Easy option is :-
> >> >> >> >>
> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> >> >> 2. Copy the backup file to Domain server
> >> >> >> >> 3. Restore the database [Use Restore Database command]
> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> >> >> follow the parent chld relationship
> >> >> >> >> while truncating table.
> >> >> >> >>
> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> >> >> SQL file. Then you could use this script to create
> >> >> >> >> objects in Domain sql server.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> Thanks
> >> >> >> >> Hari
> >> >> >> >> SQL Server MVP
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >> >> >
> >> >> >> >> > table, stored procedure .views in my application which is running well
> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> >> >> > is
> >> >> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >> >> >
> >> >> >> >> > database. can any one tell me how i can do it?
> >> >> >> >> >
> >> >> >> >
> >> >> >
> >> >
> >|||I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from your
Query Analyzer or Enterprise Manager but cannot login?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
>i want to say i don't have access of domain servers sql server
> enterprise manager and query analyser which i have registered
>
> Tibor Karaszi wrote:
>> Let me see if I understand this.
>> You have a local SQL Server with schema and data. You have script files for the DDL on your local
>> SQL Server.
>> You now want to get both the schema and data to the other SQL Server.
>> I'm confused by the comment:
>> > but i don't have direct access of domain enterprise
>> > manager or query analyzer i am having only DSN Name uid and pwd.
>> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager, right?
>> Anyhow, why not transfer the whole database using backup and restore? If you do want to script
>> out
>> the data as well as the DDL, check out some options at:
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
>> >i am having data at my local sql server but i need to transfer it on
>> > domain sql server. but i don't have direct access of domain enterprise
>> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >
>> >
>> > Tibor Karaszi wrote:
>> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
>> >> Servers?
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
>> >> > ok fine it is working but how i can transfer data from local to domain
>> >> > server.
>> >> >
>> >> > --
>> >> > Tibor Karaszi wrote:
>> >> >> Read the file from your code, take the SQL from the file you read and put it in a command
>> >> >> object.
>> >> >> Whenever you reach GO in the script file, execute what you have in the command object using
>> >> >> ExecuteNonQuery.
>> >> >>
>> >> >> --
>> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> http://www.solidqualitylearning.com/
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> >> >> > In asp.net using C#.net
>> >> >> >
>> >> >> > Tibor Karaszi wrote:
>> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> > need to run it only programatically.
>> >> >> >>
>> >> >> >> From what programming language?
>> >> >> >>
>> >> >> >> --
>> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >>
>> >> >> >>
>> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> > need to run it only programatically.
>> >> >> >> > Hari Prasad wrote:
>> >> >> >> >> Hi,
>> >> >> >> >>
>> >> >> >> >> Easy option is :-
>> >> >> >> >>
>> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> >> >> 2. Copy the backup file to Domain server
>> >> >> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> >> >> follow the parent chld relationship
>> >> >> >> >> while truncating table.
>> >> >> >> >>
>> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> >> >> SQL file. Then you could use this script to create
>> >> >> >> >> objects in Domain sql server.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> Thanks
>> >> >> >> >> Hari
>> >> >> >> >> SQL Server MVP
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >> >> >
>> >> >> >> >> > table, stored procedure .views in my application which is running well
>> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> >> >> > is
>> >> >> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >> >> >
>> >> >> >> >> > database. can any one tell me how i can do it?
>> >> >> >> >> >
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>|||Just tell me can i login to my domain servers enterprise manager or
query analyser by using DSN name.
suppose my domain is vritti.co.in and i got DSN=xyz UId =xyz Pwd=xyz.
then how i can access it by using enterprise manager or query analyser.
Tibor Karaszi wrote:
> I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from your
> Query Analyzer or Enterprise Manager but cannot login?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
> >i want to say i don't have access of domain servers sql server
> > enterprise manager and query analyser which i have registered
> >
> >
> > Tibor Karaszi wrote:
> >> Let me see if I understand this.
> >>
> >> You have a local SQL Server with schema and data. You have script files for the DDL on your local
> >> SQL Server.
> >>
> >> You now want to get both the schema and data to the other SQL Server.
> >>
> >> I'm confused by the comment:
> >>
> >> > but i don't have direct access of domain enterprise
> >> > manager or query analyzer i am having only DSN Name uid and pwd.
> >>
> >> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager, right?
> >>
> >> Anyhow, why not transfer the whole database using backup and restore? If you do want to script
> >> out
> >> the data as well as the DDL, check out some options at:
> >> http://www.karaszi.com/SQLServer/info_generate_script.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
> >> >i am having data at my local sql server but i need to transfer it on
> >> > domain sql server. but i don't have direct access of domain enterprise
> >> > manager or query analyzer i am having only DSN Name uid and pwd.
> >> >
> >> >
> >> > Tibor Karaszi wrote:
> >> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two SQL
> >> >> Servers?
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> >> >> > ok fine it is working but how i can transfer data from local to domain
> >> >> > server.
> >> >> >
> >> >> > --
> >> >> > Tibor Karaszi wrote:
> >> >> >> Read the file from your code, take the SQL from the file you read and put it in a command
> >> >> >> object.
> >> >> >> Whenever you reach GO in the script file, execute what you have in the command object using
> >> >> >> ExecuteNonQuery.
> >> >> >>
> >> >> >> --
> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> http://www.solidqualitylearning.com/
> >> >> >>
> >> >> >>
> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> >> >> >> > In asp.net using C#.net
> >> >> >> >
> >> >> >> > Tibor Karaszi wrote:
> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> >> > need to run it only programatically.
> >> >> >> >>
> >> >> >> >> From what programming language?
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> >> http://www.solidqualitylearning.com/
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> >> > need to run it only programatically.
> >> >> >> >> > Hari Prasad wrote:
> >> >> >> >> >> Hi,
> >> >> >> >> >>
> >> >> >> >> >> Easy option is :-
> >> >> >> >> >>
> >> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> >> >> >> 2. Copy the backup file to Domain server
> >> >> >> >> >> 3. Restore the database [Use Restore Database command]
> >> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> >> >> >> follow the parent chld relationship
> >> >> >> >> >> while truncating table.
> >> >> >> >> >>
> >> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> >> >> >> SQL file. Then you could use this script to create
> >> >> >> >> >> objects in Domain sql server.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> Thanks
> >> >> >> >> >> Hari
> >> >> >> >> >> SQL Server MVP
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >> >> >> >
> >> >> >> >> >> > table, stored procedure .views in my application which is running well
> >> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> >> >> >> > is
> >> >> >> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >> >> >> >
> >> >> >> >> >> > database. can any one tell me how i can do it?
> >> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >
> >> >> >
> >> >
> >|||I don't think that these tools accept DSN. You have to type in the server name (or, IP etc, as found
in your DSN), and select your login attributes (SQL Server login, login name and password).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160371392.636159.274620@.c28g2000cwb.googlegroups.com...
> Just tell me can i login to my domain servers enterprise manager or
> query analyser by using DSN name.
> suppose my domain is vritti.co.in and i got DSN=xyz UId =xyz Pwd=xyz.
> then how i can access it by using enterprise manager or query analyser.
> Tibor Karaszi wrote:
>> I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from
>> your
>> Query Analyzer or Enterprise Manager but cannot login?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
>> >i want to say i don't have access of domain servers sql server
>> > enterprise manager and query analyser which i have registered
>> >
>> >
>> > Tibor Karaszi wrote:
>> >> Let me see if I understand this.
>> >>
>> >> You have a local SQL Server with schema and data. You have script files for the DDL on your
>> >> local
>> >> SQL Server.
>> >>
>> >> You now want to get both the schema and data to the other SQL Server.
>> >>
>> >> I'm confused by the comment:
>> >>
>> >> > but i don't have direct access of domain enterprise
>> >> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >>
>> >> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager,
>> >> right?
>> >>
>> >> Anyhow, why not transfer the whole database using backup and restore? If you do want to script
>> >> out
>> >> the data as well as the DDL, check out some options at:
>> >> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
>> >> >i am having data at my local sql server but i need to transfer it on
>> >> > domain sql server. but i don't have direct access of domain enterprise
>> >> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >> >
>> >> >
>> >> > Tibor Karaszi wrote:
>> >> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two
>> >> >> SQL
>> >> >> Servers?
>> >> >>
>> >> >> --
>> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> http://www.solidqualitylearning.com/
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
>> >> >> > ok fine it is working but how i can transfer data from local to domain
>> >> >> > server.
>> >> >> >
>> >> >> > --
>> >> >> > Tibor Karaszi wrote:
>> >> >> >> Read the file from your code, take the SQL from the file you read and put it in a
>> >> >> >> command
>> >> >> >> object.
>> >> >> >> Whenever you reach GO in the script file, execute what you have in the command object
>> >> >> >> using
>> >> >> >> ExecuteNonQuery.
>> >> >> >>
>> >> >> >> --
>> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >>
>> >> >> >>
>> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> >> >> >> > In asp.net using C#.net
>> >> >> >> >
>> >> >> >> > Tibor Karaszi wrote:
>> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> >> > need to run it only programatically.
>> >> >> >> >>
>> >> >> >> >> From what programming language?
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> >> > need to run it only programatically.
>> >> >> >> >> > Hari Prasad wrote:
>> >> >> >> >> >> Hi,
>> >> >> >> >> >>
>> >> >> >> >> >> Easy option is :-
>> >> >> >> >> >>
>> >> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> >> >> >> 2. Copy the backup file to Domain server
>> >> >> >> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> >> >> >> follow the parent chld relationship
>> >> >> >> >> >> while truncating table.
>> >> >> >> >> >>
>> >> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> >> >> >> SQL file. Then you could use this script to create
>> >> >> >> >> >> objects in Domain sql server.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> Thanks
>> >> >> >> >> >> Hari
>> >> >> >> >> >> SQL Server MVP
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >> >> >> >
>> >> >> >> >> >> > table, stored procedure .views in my application which is running well
>> >> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> >> >> >> > is
>> >> >> >> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >> >> >> >
>> >> >> >> >> >> > database. can any one tell me how i can do it?
>> >> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>|||but only DSN name , uid and pwd is given to me not server name and
database name in such condition how i can transfer my data.
Tibor Karaszi wrote:
> I don't think that these tools accept DSN. You have to type in the server name (or, IP etc, as found
> in your DSN), and select your login attributes (SQL Server login, login name and password).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> news:1160371392.636159.274620@.c28g2000cwb.googlegroups.com...
> > Just tell me can i login to my domain servers enterprise manager or
> > query analyser by using DSN name.
> > suppose my domain is vritti.co.in and i got DSN=xyz UId =xyz Pwd=xyz.
> > then how i can access it by using enterprise manager or query analyser.
> >
> > Tibor Karaszi wrote:
> >> I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from
> >> your
> >> Query Analyzer or Enterprise Manager but cannot login?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
> >> >i want to say i don't have access of domain servers sql server
> >> > enterprise manager and query analyser which i have registered
> >> >
> >> >
> >> > Tibor Karaszi wrote:
> >> >> Let me see if I understand this.
> >> >>
> >> >> You have a local SQL Server with schema and data. You have script files for the DDL on your
> >> >> local
> >> >> SQL Server.
> >> >>
> >> >> You now want to get both the schema and data to the other SQL Server.
> >> >>
> >> >> I'm confused by the comment:
> >> >>
> >> >> > but i don't have direct access of domain enterprise
> >> >> > manager or query analyzer i am having only DSN Name uid and pwd.
> >> >>
> >> >> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager,
> >> >> right?
> >> >>
> >> >> Anyhow, why not transfer the whole database using backup and restore? If you do want to script
> >> >> out
> >> >> the data as well as the DDL, check out some options at:
> >> >> http://www.karaszi.com/SQLServer/info_generate_script.asp
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
> >> >> >i am having data at my local sql server but i need to transfer it on
> >> >> > domain sql server. but i don't have direct access of domain enterprise
> >> >> > manager or query analyzer i am having only DSN Name uid and pwd.
> >> >> >
> >> >> >
> >> >> > Tibor Karaszi wrote:
> >> >> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between two
> >> >> >> SQL
> >> >> >> Servers?
> >> >> >>
> >> >> >> --
> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> http://www.solidqualitylearning.com/
> >> >> >>
> >> >> >>
> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
> >> >> >> > ok fine it is working but how i can transfer data from local to domain
> >> >> >> > server.
> >> >> >> >
> >> >> >> > --
> >> >> >> > Tibor Karaszi wrote:
> >> >> >> >> Read the file from your code, take the SQL from the file you read and put it in a
> >> >> >> >> command
> >> >> >> >> object.
> >> >> >> >> Whenever you reach GO in the script file, execute what you have in the command object
> >> >> >> >> using
> >> >> >> >> ExecuteNonQuery.
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> >> http://www.solidqualitylearning.com/
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
> >> >> >> >> > In asp.net using C#.net
> >> >> >> >> >
> >> >> >> >> > Tibor Karaszi wrote:
> >> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> >> >> > need to run it only programatically.
> >> >> >> >> >>
> >> >> >> >> >> From what programming language?
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> Tibor Karaszi, SQL Server MVP
> >> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> >> >> >> http://www.solidqualitylearning.com/
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
> >> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
> >> >> >> >> >> > need to run it only programatically.
> >> >> >> >> >> > Hari Prasad wrote:
> >> >> >> >> >> >> Hi,
> >> >> >> >> >> >>
> >> >> >> >> >> >> Easy option is :-
> >> >> >> >> >> >>
> >> >> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
> >> >> >> >> >> >> 2. Copy the backup file to Domain server
> >> >> >> >> >> >> 3. Restore the database [Use Restore Database command]
> >> >> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
> >> >> >> >> >> >> follow the parent chld relationship
> >> >> >> >> >> >> while truncating table.
> >> >> >> >> >> >>
> >> >> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
> >> >> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
> >> >> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
> >> >> >> >> >> >> SQL file. Then you could use this script to create
> >> >> >> >> >> >> objects in Domain sql server.
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >> Thanks
> >> >> >> >> >> >> Hari
> >> >> >> >> >> >> SQL Server MVP
> >> >> >> >> >> >>
> >> >> >> >> >> >>
> >> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
> >> >> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
> >> >> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > table, stored procedure .views in my application which is running well
> >> >> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
> >> >> >> >> >> >> > is
> >> >> >> >> >> >> > need to create all table, stored procedure, views on the domain server
> >> >> >> >> >> >> >
> >> >> >> >> >> >> > database. can any one tell me how i can do it?
> >> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >
> >> >> >
> >> >
> >|||A DSN is something that you create locally on your machine. It contains the server name, possibly an
instance name (if not the default instance) and the database name. If they won't give you that
information, you should look for some other provider.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
news:1160408183.524642.222390@.m7g2000cwm.googlegroups.com...
> but only DSN name , uid and pwd is given to me not server name and
> database name in such condition how i can transfer my data.
> Tibor Karaszi wrote:
>> I don't think that these tools accept DSN. You have to type in the server name (or, IP etc, as
>> found
>> in your DSN), and select your login attributes (SQL Server login, login name and password).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> news:1160371392.636159.274620@.c28g2000cwb.googlegroups.com...
>> > Just tell me can i login to my domain servers enterprise manager or
>> > query analyser by using DSN name.
>> > suppose my domain is vritti.co.in and i got DSN=xyz UId =xyz Pwd=xyz.
>> > then how i can access it by using enterprise manager or query analyser.
>> >
>> > Tibor Karaszi wrote:
>> >> I still don't understand I'm afraid. Are you saying that you try to access the SQL Server from
>> >> your
>> >> Query Analyzer or Enterprise Manager but cannot login?
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> news:1160234825.895887.46100@.h48g2000cwc.googlegroups.com...
>> >> >i want to say i don't have access of domain servers sql server
>> >> > enterprise manager and query analyser which i have registered
>> >> >
>> >> >
>> >> > Tibor Karaszi wrote:
>> >> >> Let me see if I understand this.
>> >> >>
>> >> >> You have a local SQL Server with schema and data. You have script files for the DDL on your
>> >> >> local
>> >> >> SQL Server.
>> >> >>
>> >> >> You now want to get both the schema and data to the other SQL Server.
>> >> >>
>> >> >> I'm confused by the comment:
>> >> >>
>> >> >> > but i don't have direct access of domain enterprise
>> >> >> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >> >>
>> >> >> If you have a local SQL Server, you would have both Query Analyzer and Enterprise Manager,
>> >> >> right?
>> >> >>
>> >> >> Anyhow, why not transfer the whole database using backup and restore? If you do want to
>> >> >> script
>> >> >> out
>> >> >> the data as well as the DDL, check out some options at:
>> >> >> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> >> >>
>> >> >> --
>> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> http://www.solidqualitylearning.com/
>> >> >>
>> >> >>
>> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> news:1160198245.515066.96750@.m7g2000cwm.googlegroups.com...
>> >> >> >i am having data at my local sql server but i need to transfer it on
>> >> >> > domain sql server. but i don't have direct access of domain enterprise
>> >> >> > manager or query analyzer i am having only DSN Name uid and pwd.
>> >> >> >
>> >> >> >
>> >> >> > Tibor Karaszi wrote:
>> >> >> >> I'm not sure what you are asking here. What data do you refer to, where is it? Between
>> >> >> >> two
>> >> >> >> SQL
>> >> >> >> Servers?
>> >> >> >>
>> >> >> >> --
>> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >>
>> >> >> >>
>> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> news:1160108798.342356.275430@.e3g2000cwe.googlegroups.com...
>> >> >> >> > ok fine it is working but how i can transfer data from local to domain
>> >> >> >> > server.
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> > Tibor Karaszi wrote:
>> >> >> >> >> Read the file from your code, take the SQL from the file you read and put it in a
>> >> >> >> >> command
>> >> >> >> >> object.
>> >> >> >> >> Whenever you reach GO in the script file, execute what you have in the command object
>> >> >> >> >> using
>> >> >> >> >> ExecuteNonQuery.
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> news:1160023668.433979.75200@.i42g2000cwa.googlegroups.com...
>> >> >> >> >> > In asp.net using C#.net
>> >> >> >> >> >
>> >> >> >> >> > Tibor Karaszi wrote:
>> >> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> >> >> > need to run it only programatically.
>> >> >> >> >> >>
>> >> >> >> >> >> From what programming language?
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >> Tibor Karaszi, SQL Server MVP
>> >> >> >> >> >> http://www.karaszi.com/sqlserver/default.asp
>> >> >> >> >> >> http://www.solidqualitylearning.com/
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> >> news:1159939062.047937.268110@.k70g2000cwa.googlegroups.com...
>> >> >> >> >> >> > but i am not having access of enterprise manager of domain server. i
>> >> >> >> >> >> > need to run it only programatically.
>> >> >> >> >> >> > Hari Prasad wrote:
>> >> >> >> >> >> >> Hi,
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Easy option is :-
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> 1. Backup the database in your machine [Use Backup Database]
>> >> >> >> >> >> >> 2. Copy the backup file to Domain server
>> >> >> >> >> >> >> 3. Restore the database [Use Restore Database command]
>> >> >> >> >> >> >> 4. If you do not want the data then Truncate the contents of all tables.
>> >> >> >> >> >> >> follow the parent chld relationship
>> >> >> >> >> >> >> while truncating table.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Alternative is ... In the local sql server .. open enterprise manager..
>> >> >> >> >> >> >> Select database .. right click-- all tasks-- Generate SQL Scripts...
>> >> >> >> >> >> >> choose all objects , all dependant objects -- permissions...Script it as a
>> >> >> >> >> >> >> SQL file. Then you could use this script to create
>> >> >> >> >> >> >> objects in Domain sql server.
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> Thanks
>> >> >> >> >> >> >> Hari
>> >> >> >> >> >> >> SQL Server MVP
>> >> >> >> >> >> >>
>> >> >> >> >> >> >>
>> >> >> >> >> >> >> "santosh" <Santoshmshinde_it@.yahoo.com> wrote in message
>> >> >> >> >> >> >> news:1159607442.786501.105340@.e3g2000cwe.googlegroups.com...
>> >> >> >> >> >> >> > dear all i am using ASP.net ,c# and SQL server 2000. i have create all
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > table, stored procedure .views in my application which is running well
>> >> >> >> >> >> >> > in localhost but now i want to deploy it on server. for that pupose i
>> >> >> >> >> >> >> > is
>> >> >> >> >> >> >> > need to create all table, stored procedure, views on the domain server
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >> > database. can any one tell me how i can do it?
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>

Wednesday, March 28, 2012

Running a Stored procedure or a query

running a script to create a database in MSDE

Running a report to populate a cell

Friday, March 23, 2012

Running 2005 SSIS Jobs on 2000

Running 2005 AS on 2000 DB, or should I upgrade 2000 Server to 2005?

RunCommands problem in Setup.lst

Wednesday, March 21, 2012

Run Time parameter query

Run Time parameter query

Run Time parameter query

run time error

Run SQL-Server Query in Excel

Run SQL-Server Query in Excel

Run Sql Stored Procedure From Excel

run sql script on sql server2000

run sql script on sql server2000

run sql script on sql server2000

RSS Text Data Mining

Blog Archive

About Me