Hi Folks,
I've created a SQL Server database and converted it to Oracle (an app we
made supports MSSQL and Oracle) and I'd like to be able to provide a
"server-side" installation that clients can run on their database server
that would automatically create the MSSQL or Oracle database, the tables,
index, relationships, etc. and insert the needed data for a "new" database.
I have very little experience in the realm of database setup & installation.
Has anyone ever done this before and if so, what product/technology did you
use? I've been searching the newsgroups and haven't found much useful info
on the topic. Am I looking in the wrong place?
Thanks,
Jason-- Jason wrote: --
>> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app we
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new" database.
--
Hi Jason,
This is a fairly trivial exercise. Have a look at the sample *.sql scripts that automatically creates the sample Northwind and Pubs database when you install SQL Server. They will give you some idea on how to automatically create a database and objects within that database.
The files are instnwnd.sql and instpubs.sql to install Northwind and Pubs, respectively. The files can be found on your <drive>:\Program Files\Microsoft SQL Server\MSSQL\Install folder
Hope this helps,
-Eric Cárdenas
SQL Server support|||You could, from your install program, either spawn OSQL with your script file (see Eric's post) as
input parameter. Or you can write your own app which reads the file and execute the TSQL statements
in the script file. Or you could, of course, embed the various CREATE statements inside your setup
programs source code.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...
> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app we
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new" database.
> I have very little experience in the realm of database setup & installation.
> Has anyone ever done this before and if so, what product/technology did you
> use? I've been searching the newsgroups and haven't found much useful info
> on the topic. Am I looking in the wrong place?
> Thanks,
> Jason
>|||I would probably
1. Script out Your DB. This will enable you to create a blank version of
your DB somewhere else.
2. Have your standing data in text files and use BULK INSERT or bcp
statements to load it into the tables.
3. Use osql to load the scripts you have created.
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\co
prompt.chm::/cp_osql_1wxl.htm)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...
> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app
we
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new"
database.
> I have very little experience in the realm of database setup &
installation.
> Has anyone ever done this before and if so, what product/technology did
you
> use? I've been searching the newsgroups and haven't found much useful info
> on the topic. Am I looking in the wrong place?
> Thanks,
> Jason
>|||Thanks for the responses from everyone. I'm aware I can provide someone with
.sql scripts...what I'm more interested in though is an installation I can
provide that goes something like this:
User runs Setup.exe to luanch the setup.
During Setup, one of the screens prompts them to enter the db information
(name of the server, un/pw)
Then setup takes that information and runs the DDL scripts against the
server they provided.
Are there any products (like Wise or Installshield maybe) that help automate
the creation of setups to do this or am I looking at needing to write my own
custom setup program?
Jason
"Eric Cardenas" <anonymous@.discussions.microsoft.com> wrote in message
news:BE41F8CB-4DBA-439D-A034-32CF737D0ED0@.microsoft.com...
> -- Jason wrote: --
> >> Hi Folks,
> > I've created a SQL Server database and converted it to Oracle (an app
we
> > made supports MSSQL and Oracle) and I'd like to be able to provide a
> > "server-side" installation that clients can run on their database
server
> > that would automatically create the MSSQL or Oracle database, the
tables,
> > index, relationships, etc. and insert the needed data for a "new"
database.
> --
> Hi Jason,
> This is a fairly trivial exercise. Have a look at the sample *.sql scripts
that automatically creates the sample Northwind and Pubs database when you
install SQL Server. They will give you some idea on how to automatically
create a database and objects within that database.
> The files are instnwnd.sql and instpubs.sql to install Northwind and Pubs,
respectively. The files can be found on your <drive>:\Program
Files\Microsoft SQL Server\MSSQL\Install folder
> Hope this helps,
> -Eric Cárdenas
> SQL Server support
>
Showing posts with label folks. Show all posts
Showing posts with label folks. Show all posts
Wednesday, March 21, 2012
Database Setup Package/Installation
Hi Folks,
I've created a SQL Server database and converted it to Oracle (an app we
made supports MSSQL and Oracle) and I'd like to be able to provide a
"server-side" installation that clients can run on their database server
that would automatically create the MSSQL or Oracle database, the tables,
index, relationships, etc. and insert the needed data for a "new" database.
I have very little experience in the realm of database setup & installation.
Has anyone ever done this before and if so, what product/technology did you
use? I've been searching the newsgroups and haven't found much useful info
on the topic. Am I looking in the wrong place?
Thanks,
JasonYou can create scripts to do this. You can find similar
scripts from the installation of databases on SQL Server.
For an example, check the script that creates the Northwinds
database. The file is instnwnd.sql and it's located in the
install subdirectory under MSSQL, e.g.
C:\Program Files\Microsoft SQL Server\MSSQL\Install
-Sue
On Tue, 2 Dec 2003 14:35:53 -0800, "Jason"
<jasonmauss_nospam@.vsdotnetguru.com> wrote:
e (see Eric's post) as
input parameter. Or you can write your own app which reads the file and exec
ute the TSQL statements
in the script file. Or you could, of course, embed the various CREATE statem
ents inside your setup
programs source code.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...
1. Script out Your DB. This will enable you to create a blank version of
your DB somewhere else.
2. Have your standing data in text files and use BULK INSERT or bcp
statements to load it into the tables.
3. Use osql to load the scripts you have created.
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\co
prompt.chm::/cp_osql_1wxl.htm)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...
we
database.
installation.
you
.sql scripts...what I'm more interested in though is an installation I can
provide that goes something like this:
User runs Setup.exe to luanch the setup.
During Setup, one of the screens prompts them to enter the db information
(name of the server, un/pw)
Then setup takes that information and runs the DDL scripts against the
server they provided.
Are there any products (like Wise or Installshield maybe) that help automate
the creation of setups to do this or am I looking at needing to write my own
custom setup program?
Jason
"Eric Cardenas" <anonymous@.discussions.microsoft.com> wrote in message
news:BE41F8CB-4DBA-439D-A034-32CF737D0ED0@.microsoft.com...
that automatically creates the sample Northwind and Pubs database when you
install SQL Server. They will give you some idea on how to automatically
create a database and objects within that database.
respectively. The files can be found on your <drive>:\Program
Files\Microsoft SQL Server\MSSQL\Install folder
I've created a SQL Server database and converted it to Oracle (an app we
made supports MSSQL and Oracle) and I'd like to be able to provide a
"server-side" installation that clients can run on their database server
that would automatically create the MSSQL or Oracle database, the tables,
index, relationships, etc. and insert the needed data for a "new" database.
I have very little experience in the realm of database setup & installation.
Has anyone ever done this before and if so, what product/technology did you
use? I've been searching the newsgroups and haven't found much useful info
on the topic. Am I looking in the wrong place?
Thanks,
JasonYou can create scripts to do this. You can find similar
scripts from the installation of databases on SQL Server.
For an example, check the script that creates the Northwinds
database. The file is instnwnd.sql and it's located in the
install subdirectory under MSSQL, e.g.
C:\Program Files\Microsoft SQL Server\MSSQL\Install
-Sue
On Tue, 2 Dec 2003 14:35:53 -0800, "Jason"
<jasonmauss_nospam@.vsdotnetguru.com> wrote:
quote:|||You could, from your install program, either spawn OSQL with your script fil
>Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app w
e
>made supports MSSQL and Oracle) and I'd like to be able to provide a
>"server-side" installation that clients can run on their database server
>that would automatically create the MSSQL or Oracle database, the tables,
>index, relationships, etc. and insert the needed data for a "new" database.
>I have very little experience in the realm of database setup & installation
.
>Has anyone ever done this before and if so, what product/technology did you
>use? I've been searching the newsgroups and haven't found much useful info
>on the topic. Am I looking in the wrong place?
>Thanks,
>Jason
>
e (see Eric's post) as
input parameter. Or you can write your own app which reads the file and exec
ute the TSQL statements
in the script file. Or you could, of course, embed the various CREATE statem
ents inside your setup
programs source code.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...
quote:|||I would probably
> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app
we
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new" database
.
> I have very little experience in the realm of database setup & installatio
n.
> Has anyone ever done this before and if so, what product/technology did yo
u
> use? I've been searching the newsgroups and haven't found much useful info
> on the topic. Am I looking in the wrong place?
> Thanks,
> Jason
>
1. Script out Your DB. This will enable you to create a blank version of
your DB somewhere else.
2. Have your standing data in text files and use BULK INSERT or bcp
statements to load it into the tables.
3. Use osql to load the scripts you have created.
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\co
prompt.chm::/cp_osql_1wxl.htm)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jason" <jasonmauss_nospam@.vsdotnetguru.com> wrote in message
news:%23KeLsTSuDHA.2244@.TK2MSFTNGP09.phx.gbl...
quote:
> Hi Folks,
> I've created a SQL Server database and converted it to Oracle (an app
we
quote:
> made supports MSSQL and Oracle) and I'd like to be able to provide a
> "server-side" installation that clients can run on their database server
> that would automatically create the MSSQL or Oracle database, the tables,
> index, relationships, etc. and insert the needed data for a "new"
database.
quote:
> I have very little experience in the realm of database setup &
installation.
quote:
> Has anyone ever done this before and if so, what product/technology did
you
quote:|||Thanks for the responses from everyone. I'm aware I can provide someone with
> use? I've been searching the newsgroups and haven't found much useful info
> on the topic. Am I looking in the wrong place?
> Thanks,
> Jason
>
.sql scripts...what I'm more interested in though is an installation I can
provide that goes something like this:
User runs Setup.exe to luanch the setup.
During Setup, one of the screens prompts them to enter the db information
(name of the server, un/pw)
Then setup takes that information and runs the DDL scripts against the
server they provided.
Are there any products (like Wise or Installshield maybe) that help automate
the creation of setups to do this or am I looking at needing to write my own
custom setup program?
Jason
"Eric Cardenas" <anonymous@.discussions.microsoft.com> wrote in message
news:BE41F8CB-4DBA-439D-A034-32CF737D0ED0@.microsoft.com...
quote:
> -- Jason wrote: --
we[QUOTE]
server[QUOTE]
tables,[QUOTE]
database.[QUOTE]
> --
> Hi Jason,
> This is a fairly trivial exercise. Have a look at the sample *.sql scripts
that automatically creates the sample Northwind and Pubs database when you
install SQL Server. They will give you some idea on how to automatically
create a database and objects within that database.
quote:
> The files are instnwnd.sql and instpubs.sql to install Northwind and Pubs,
respectively. The files can be found on your <drive>:\Program
Files\Microsoft SQL Server\MSSQL\Install folder
quote:
> Hope this helps,
> -Eric Crdenas
> SQL Server support
>
Monday, March 19, 2012
Database Search Engine
Hi folks,
Whts up......? M back, after a long gap.
I have come across with a major issue. And u know wht th issue is.......?
It is about th DATABASE SEARCH TOOL. I have a database of around 30 tables. Now I wud like to have aa search engine on my .asp page. There will be a text box on th page and one submit button. After typing some text in th text area n submitting th page, my package sud check tht perticular text in all th COLUMNS of all th TABLES, n whrevr it gets a match (exactly same, or by speech recognition), it sud through th links on th next page.
Nw i wud like u guys to take this problem, at th earliest n come up with a up to th mark solution.
ThnkxYou will probably want to use SQL Server's full-text search capability.
But...
...you are going to allow web page viewers to issue non-sargable searches of every value of every column in every table in your database? That sounds insane to me. What kind of performance to you expect?|||Aside from the issues the blind dude mentions, I'm sure we've all "played' with this...
You need dynamic sql and a select against the information schema columns view...
EDIT: AND a cursor, AND a temp or table variable to hold the results...
what do you plan to do about dates and numbers?|||Oh come on! I understand the requirement is somewhat fishy, but this is not a homework where just the solution is needed! If you REALLY need to search for a pattern (even if it's exact) in every field of every table, - why would one want to use dynamic SQL or a cursor or a combination there of? Unless your intention is to kill the server with the second connection while the first one is still doing this insanity?
You'll need to write a function for all tables that will transpose all the char-based columns into one column with UNION ALL and a CAST to accomodate for the widest field and a WHERE clause for each participant of the UNION with the pattern that you're looking for. The second column should be a table identifier and possibly the third should be the PK from the table (I hope, contrary to "some" opinions that you're using INT/BIGINT for your PKs). Then you fire this function from the stored procedure that further manipulates the results. At THAT point, and at that point only, you may have to use dynamic SQL, and possibly a cursor, if the retrieval of the "links" will involve selection from the tables that appeared from the execution of the function mentioned above.
EDITED: And while writing the participants of the UNION, make sure to use either READ UNCOMMITTED isolation level, or NOLOCK table hint, UNLESS (!!!) DML operations that may be performed on the affected tables is important.|||I'm speechless....|||Well, that's ANOTHER way to skin the cat...
...but it's still going to scream bloody murder while you're peeling off the fur.|||Here's a sp I found you can get started with.|||Yup, ANOTHER way would be to implement Full-Text Search and use CONTAINSTABLE while UNIONed ALL 30 times. Either way it's a case of animal abuse ;)|||Yup, ANOTHER way would be to implement Full-Text Search and use CONTAINSTABLE while UNIONed ALL 30 times. Either way it's a case of animal abuse ;)Yeah, but as long as it is just a cat...
-PatP|||Well, that's ANOTHER way to skin the cat...
...but it's still going to scream bloody murder while you're peeling off the fur.
You crack me up.....|||Thnkx folks,
Thnkx for ur help. Though I hv'nt started th work suggested by u people.........as th week passed was tight. Lemme give a try n see what comes.
Thnkx 1nc again|||implement full text indexing on the columns that you wish to search
and use the following functions
contains, freetext, containstable and freetextable.
this is much better than like and dynamic sql because of the "Linguistic based search" ability of the fulltext service
to search long unstructured text in the where clause use freetext
to use the most powerfull and most focused of the 4 choose contains in the where clause (contains will find prefix terms , inflectional, generational and other forms of searches)
to search a table based result set use containstable or freetextable
the diff is that you place these in the from clause of your select.
good luck|||Check this site: http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
Whts up......? M back, after a long gap.
I have come across with a major issue. And u know wht th issue is.......?
It is about th DATABASE SEARCH TOOL. I have a database of around 30 tables. Now I wud like to have aa search engine on my .asp page. There will be a text box on th page and one submit button. After typing some text in th text area n submitting th page, my package sud check tht perticular text in all th COLUMNS of all th TABLES, n whrevr it gets a match (exactly same, or by speech recognition), it sud through th links on th next page.
Nw i wud like u guys to take this problem, at th earliest n come up with a up to th mark solution.
ThnkxYou will probably want to use SQL Server's full-text search capability.
But...
...you are going to allow web page viewers to issue non-sargable searches of every value of every column in every table in your database? That sounds insane to me. What kind of performance to you expect?|||Aside from the issues the blind dude mentions, I'm sure we've all "played' with this...
You need dynamic sql and a select against the information schema columns view...
EDIT: AND a cursor, AND a temp or table variable to hold the results...
what do you plan to do about dates and numbers?|||Oh come on! I understand the requirement is somewhat fishy, but this is not a homework where just the solution is needed! If you REALLY need to search for a pattern (even if it's exact) in every field of every table, - why would one want to use dynamic SQL or a cursor or a combination there of? Unless your intention is to kill the server with the second connection while the first one is still doing this insanity?
You'll need to write a function for all tables that will transpose all the char-based columns into one column with UNION ALL and a CAST to accomodate for the widest field and a WHERE clause for each participant of the UNION with the pattern that you're looking for. The second column should be a table identifier and possibly the third should be the PK from the table (I hope, contrary to "some" opinions that you're using INT/BIGINT for your PKs). Then you fire this function from the stored procedure that further manipulates the results. At THAT point, and at that point only, you may have to use dynamic SQL, and possibly a cursor, if the retrieval of the "links" will involve selection from the tables that appeared from the execution of the function mentioned above.
EDITED: And while writing the participants of the UNION, make sure to use either READ UNCOMMITTED isolation level, or NOLOCK table hint, UNLESS (!!!) DML operations that may be performed on the affected tables is important.|||I'm speechless....|||Well, that's ANOTHER way to skin the cat...
...but it's still going to scream bloody murder while you're peeling off the fur.|||Here's a sp I found you can get started with.|||Yup, ANOTHER way would be to implement Full-Text Search and use CONTAINSTABLE while UNIONed ALL 30 times. Either way it's a case of animal abuse ;)|||Yup, ANOTHER way would be to implement Full-Text Search and use CONTAINSTABLE while UNIONed ALL 30 times. Either way it's a case of animal abuse ;)Yeah, but as long as it is just a cat...
-PatP|||Well, that's ANOTHER way to skin the cat...
...but it's still going to scream bloody murder while you're peeling off the fur.
You crack me up.....|||Thnkx folks,
Thnkx for ur help. Though I hv'nt started th work suggested by u people.........as th week passed was tight. Lemme give a try n see what comes.
Thnkx 1nc again|||implement full text indexing on the columns that you wish to search
and use the following functions
contains, freetext, containstable and freetextable.
this is much better than like and dynamic sql because of the "Linguistic based search" ability of the fulltext service
to search long unstructured text in the where clause use freetext
to use the most powerfull and most focused of the 4 choose contains in the where clause (contains will find prefix terms , inflectional, generational and other forms of searches)
to search a table based result set use containstable or freetextable
the diff is that you place these in the from clause of your select.
good luck|||Check this site: http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
Subscribe to:
Posts (Atom)