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?
>> >> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >
>> >> >> >
>> >> >
>> >
>