master script to build database
Tech-Archive recommends: Fix windows errors by optimizing your registry
Date: Wed, 22 Sep 2004 19:53:28 -0700
i would like to build a master .sql file that builds up my database from
scratch ...
1. runs various .sql files each which creates a table
2. runs a .sql file that creates various foreign keys
3. imports various .txt files into the various tables
how to do this ?
Relevant Pages
- Re: Execute more sql statments in one step.
... Before today the update works only for the client binary and not for the database structure. ... It's, for me, more easy to create an unique .sql file which contains all the sql statments needs to modify the database, instead of a lot of files with single sql statments. ... There's no way to connect directly the mysql of the client so i've to do it from java. ...
(comp.lang.java.databases) - Re: Automate DB update
... Can't you just send them the script file that they would run ... correct database and specify dbo as the owner of objects. ... > first if there is a different version of exe on the server. ... I send the script to my client as sql file. ...
(microsoft.public.sqlserver.programming) - Re: Automate DB update
... Can't you just send them the script file that they would run ... correct database and specify dbo as the owner of objects. ... > first if there is a different version of exe on the server. ... I send the script to my client as sql file. ...
(microsoft.public.vb.database) - Re: Automate DB update
... Can't you just send them the script file that they would run ... correct database and specify dbo as the owner of objects. ... > first if there is a different version of exe on the server. ... I send the script to my client as sql file. ...
(microsoft.public.vb.database.ado) - Re: default database for opening a .sql file?
... If you want to be in the ..sql file, just add USE dbname in the beginning of the file. ... create a project including this file and the database information is in the project file. ... Tibor Karaszi, SQL Server MVP ... I clicked it and on the Connection Properties tab it had the same "connect to database" dropdown that I used to set the default for new query windows. ...
(microsoft.public.sqlserver.tools) |
|
