|
|
You're in the
visual c libraries
group:HOWTO create a copy of one database
visual c libraries:
Yes. Create a script and deploy it.
-- -oj RAC v2.2 & QALite! http://www.rac4sql.net [quoted text, click to view] "Lars Grøtteland" <lars@nospam> wrote in message news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > Hello! > > Was wondering how I can create a copy of one database? FYI I'm not > interrested in the data, just the fields and triggers, and so on. > > Which way is the easiest? Do I create a script and run it from there? Is it > smart to have it inside a SP? > > Any idea would be greatly appreciated. > > I'm programming SQL 2k and VC7.0 > > -- > > > - Lars > > >
Hello!
Was wondering how I can create a copy of one database? FYI I'm not interrested in the data, just the fields and triggers, and so on. Which way is the easiest? Do I create a script and run it from there? Is it smart to have it inside a SP? Any idea would be greatly appreciated. I'm programming SQL 2k and VC7.0 -- - Lars
Yes I know I can do this in QA, but how to do it in my application?
Was thinking of making a SP, inside the model database. I think I've read of this database once - that if I create one SP inside this, this should be copied to the new database that's been created. Is this a solution? -- - Lars [quoted text, click to view] "oj" <nospam_ojngo@home.com> wrote in message news:uysZi11pDHA.1728@TK2MSFTNGP09.phx.gbl... > Yes. Create a script and deploy it. > > -- > -oj > RAC v2.2 & QALite! > http://www.rac4sql.net > > > > "Lars Grøtteland" <lars@nospam> wrote in message > news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > > Hello! > > > > Was wondering how I can create a copy of one database? FYI I'm not > > interrested in the data, just the fields and triggers, and so on. > > > > Which way is the easiest? Do I create a script and run it from there? Is > it > > smart to have it inside a SP? > > > > Any idea would be greatly appreciated. > > > > I'm programming SQL 2k and VC7.0 > > > > -- > > > > > > - Lars > > > > > > > >
Lars
Right click on the database then All tasks then Generate SQL Script. Save it as .sql (or whatever) file and you can run it from QA or later if you need from the file. [quoted text, click to view] "Lars Grøtteland" <lars@nospam> wrote in message news:#BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > Hello! > > Was wondering how I can create a copy of one database? FYI I'm not > interrested in the data, just the fields and triggers, and so on. > > Which way is the easiest? Do I create a script and run it from there? Is it > smart to have it inside a SP? > > Any idea would be greatly appreciated. > > I'm programming SQL 2k and VC7.0 > > -- > > > - Lars > > >
If you want to do it from inside you application, use SQL-DMO. You can copy
the complete database without using a script with the Database.Transfer method, or you can generate a script with the Database.Script method. Both method have a rather long list of parameters, which is a bit too much to mention here, but whihc you can find in Books Online. The parameters basically allow you all the options you have when copying a database or generating a script from Enterprise Manager. -- Jacco Schalkwijk SQL Server MVP [quoted text, click to view] "Lars Grøtteland" <lars@nospam> wrote in message news:%23fvQzD2pDHA.648@TK2MSFTNGP11.phx.gbl... > Yes I know I can do this in QA, but how to do it in my application? > > Was thinking of making a SP, inside the model database. I think I've read of > this database once - that if I create one SP inside this, this should be > copied to the new database that's been created. Is this a solution? > > -- > > > - Lars > > > "oj" <nospam_ojngo@home.com> wrote in message > news:uysZi11pDHA.1728@TK2MSFTNGP09.phx.gbl... > > Yes. Create a script and deploy it. > > > > -- > > -oj > > RAC v2.2 & QALite! > > http://www.rac4sql.net > > > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > > > Hello! > > > > > > Was wondering how I can create a copy of one database? FYI I'm not > > > interrested in the data, just the fields and triggers, and so on. > > > > > > Which way is the easiest? Do I create a script and run it from there? Is > > it > > > smart to have it inside a SP? > > > > > > Any idea would be greatly appreciated. > > > > > > I'm programming SQL 2k and VC7.0 > > > > > > -- > > > > > > > > > - Lars > > > > > > > > > > > > > > >
Yes, stuff from model are copied to a new database. But this seems to be a
real awkward way of doing it. Just generate the scrip and have your application loop the script file and for each "GO" it encounters in the file is executes what you have built in the buffer so far. -- Tibor Karaszi, SQL Server MVP Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver [quoted text, click to view] "Lars Grøtteland" <lars@nospam> wrote in message news:%23fvQzD2pDHA.648@TK2MSFTNGP11.phx.gbl... > Yes I know I can do this in QA, but how to do it in my application? > > Was thinking of making a SP, inside the model database. I think I've read of > this database once - that if I create one SP inside this, this should be > copied to the new database that's been created. Is this a solution? > > -- > > > - Lars > > > "oj" <nospam_ojngo@home.com> wrote in message > news:uysZi11pDHA.1728@TK2MSFTNGP09.phx.gbl... > > Yes. Create a script and deploy it. > > > > -- > > -oj > > RAC v2.2 & QALite! > > http://www.rac4sql.net > > > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > > > Hello! > > > > > > Was wondering how I can create a copy of one database? FYI I'm not > > > interrested in the data, just the fields and triggers, and so on. > > > > > > Which way is the easiest? Do I create a script and run it from there? Is > > it > > > smart to have it inside a SP? > > > > > > Any idea would be greatly appreciated. > > > > > > I'm programming SQL 2k and VC7.0 > > > > > > -- > > > > > > > > > - Lars > > > > > > > > > > > > > > >
Then I have another trick for you!
I have "GOTO" inside the script. What should I do then? -- - Lars "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> [quoted text, click to view] wrote in message news:OMZRlv2pDHA.2500@TK2MSFTNGP10.phx.gbl... > Yes, stuff from model are copied to a new database. But this seems to be a > real awkward way of doing it. Just generate the scrip and have your > application loop the script file and for each "GO" it encounters in the file > is executes what you have built in the buffer so far. > > -- > Tibor Karaszi, SQL Server MVP > Archive at: > http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver > > > "Lars Grøtteland" <lars@nospam> wrote in message > news:%23fvQzD2pDHA.648@TK2MSFTNGP11.phx.gbl... > > Yes I know I can do this in QA, but how to do it in my application? > > > > Was thinking of making a SP, inside the model database. I think I've read > of > > this database once - that if I create one SP inside this, this should be > > copied to the new database that's been created. Is this a solution? > > > > -- > > > > > > - Lars > > > > > > "oj" <nospam_ojngo@home.com> wrote in message > > news:uysZi11pDHA.1728@TK2MSFTNGP09.phx.gbl... > > > Yes. Create a script and deploy it. > > > > > > -- > > > -oj > > > RAC v2.2 & QALite! > > > http://www.rac4sql.net > > > > > > > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > > news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > > > > Hello! > > > > > > > > Was wondering how I can create a copy of one database? FYI I'm not > > > > interrested in the data, just the fields and triggers, and so on. > > > > > > > > Which way is the easiest? Do I create a script and run it from there? > Is > > > it > > > > smart to have it inside a SP? > > > > > > > > Any idea would be greatly appreciated. > > > > > > > > I'm programming SQL 2k and VC7.0 > > > > > > > > -- > > > > > > > > > > > > - Lars > > > > > > > > > > > > > > > > > > > > > > > >
No problem. Just check that the first character after GO (i.e., the third
character as GO must be first two characters on the line) is either blank, tab or CR or NL (new line). -- Tibor Karaszi, SQL Server MVP Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver [quoted text, click to view] "Lars Grøtteland" <lars@nospam> wrote in message news:uyawtK3pDHA.3256@tk2msftngp13.phx.gbl... > Then I have another trick for you! > > I have "GOTO" inside the script. What should I do then? > > -- > > > - Lars > > > "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> > wrote in message news:OMZRlv2pDHA.2500@TK2MSFTNGP10.phx.gbl... > > Yes, stuff from model are copied to a new database. But this seems to be a > > real awkward way of doing it. Just generate the scrip and have your > > application loop the script file and for each "GO" it encounters in the > file > > is executes what you have built in the buffer so far. > > > > -- > > Tibor Karaszi, SQL Server MVP > > Archive at: > > > http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > news:%23fvQzD2pDHA.648@TK2MSFTNGP11.phx.gbl... > > > Yes I know I can do this in QA, but how to do it in my application? > > > > > > Was thinking of making a SP, inside the model database. I think I've > read > > of > > > this database once - that if I create one SP inside this, this should > be > > > copied to the new database that's been created. Is this a solution? > > > > > > -- > > > > > > > > > - Lars > > > > > > > > > "oj" <nospam_ojngo@home.com> wrote in message > > > news:uysZi11pDHA.1728@TK2MSFTNGP09.phx.gbl... > > > > Yes. Create a script and deploy it. > > > > > > > > -- > > > > -oj > > > > RAC v2.2 & QALite! > > > > http://www.rac4sql.net > > > > > > > > > > > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > > > news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > > > > > Hello! > > > > > > > > > > Was wondering how I can create a copy of one database? FYI I'm not > > > > > interrested in the data, just the fields and triggers, and so on. > > > > > > > > > > Which way is the easiest? Do I create a script and run it from > there? > > Is > > > > it > > > > > smart to have it inside a SP? > > > > > > > > > > Any idea would be greatly appreciated. > > > > > > > > > > I'm programming SQL 2k and VC7.0 > > > > > > > > > > -- > > > > > > > > > > > > > > > - Lars > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
In the Books Online index:
objects-SQL-DMO, Database methods-SQL-DMO, Transfer objects-SQL-DMO, Transfer objects-SQL-DMO, Transfer2 I couldn't find any examples in C++, but here is one in VB: http://sqldev.net/download/sqldmo/80/vb6/TransferEvent.cls.txt -- Jacco Schalkwijk SQL Server MVP [quoted text, click to view] "Lars Grøtteland" <lars@nospam> wrote in message news:uRAwq23pDHA.688@TK2MSFTNGP10.phx.gbl... > What's the syntax - or where can I find it in SQL-DMO bol > > > -- > > > - Lars > > > "Jacco Schalkwijk" <NOSPAMjaccos@eurostop.co.uk> wrote in message > news:uvJ$E22pDHA.1656@tk2msftngp13.phx.gbl... > > If you want to do it from inside you application, use SQL-DMO. You can > copy > > the complete database without using a script with the Database.Transfer > > method, or you can generate a script with the Database.Script method. Both > > method have a rather long list of parameters, which is a bit too much to > > mention here, but whihc you can find in Books Online. The parameters > > basically allow you all the options you have when copying a database or > > generating a script from Enterprise Manager. > > > > -- > > Jacco Schalkwijk > > SQL Server MVP > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > news:%23fvQzD2pDHA.648@TK2MSFTNGP11.phx.gbl... > > > Yes I know I can do this in QA, but how to do it in my application? > > > > > > Was thinking of making a SP, inside the model database. I think I've > read > > of > > > this database once - that if I create one SP inside this, this should > be > > > copied to the new database that's been created. Is this a solution? > > > > > > -- > > > > > > > > > - Lars > > > > > > > > > "oj" <nospam_ojngo@home.com> wrote in message > > > news:uysZi11pDHA.1728@TK2MSFTNGP09.phx.gbl... > > > > Yes. Create a script and deploy it. > > > > > > > > -- > > > > -oj > > > > RAC v2.2 & QALite! > > > > http://www.rac4sql.net > > > > > > > > > > > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > > > news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > > > > > Hello! > > > > > > > > > > Was wondering how I can create a copy of one database? FYI I'm not > > > > > interrested in the data, just the fields and triggers, and so on. > > > > > > > > > > Which way is the easiest? Do I create a script and run it from > there? > > Is > > > > it > > > > > smart to have it inside a SP? > > > > > > > > > > Any idea would be greatly appreciated. > > > > > > > > > > I'm programming SQL 2k and VC7.0 > > > > > > > > > > -- > > > > > > > > > > > > > > > - Lars > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
What's the syntax - or where can I find it in SQL-DMO bol
-- - Lars [quoted text, click to view] "Jacco Schalkwijk" <NOSPAMjaccos@eurostop.co.uk> wrote in message news:uvJ$E22pDHA.1656@tk2msftngp13.phx.gbl... > If you want to do it from inside you application, use SQL-DMO. You can copy > the complete database without using a script with the Database.Transfer > method, or you can generate a script with the Database.Script method. Both > method have a rather long list of parameters, which is a bit too much to > mention here, but whihc you can find in Books Online. The parameters > basically allow you all the options you have when copying a database or > generating a script from Enterprise Manager. > > -- > Jacco Schalkwijk > SQL Server MVP > > > "Lars Grøtteland" <lars@nospam> wrote in message > news:%23fvQzD2pDHA.648@TK2MSFTNGP11.phx.gbl... > > Yes I know I can do this in QA, but how to do it in my application? > > > > Was thinking of making a SP, inside the model database. I think I've read > of > > this database once - that if I create one SP inside this, this should be > > copied to the new database that's been created. Is this a solution? > > > > -- > > > > > > - Lars > > > > > > "oj" <nospam_ojngo@home.com> wrote in message > > news:uysZi11pDHA.1728@TK2MSFTNGP09.phx.gbl... > > > Yes. Create a script and deploy it. > > > > > > -- > > > -oj > > > RAC v2.2 & QALite! > > > http://www.rac4sql.net > > > > > > > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > > news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > > > > Hello! > > > > > > > > Was wondering how I can create a copy of one database? FYI I'm not > > > > interrested in the data, just the fields and triggers, and so on. > > > > > > > > Which way is the easiest? Do I create a script and run it from there? > Is > > > it > > > > smart to have it inside a SP? > > > > > > > > Any idea would be greatly appreciated. > > > > > > > > I'm programming SQL 2k and VC7.0 > > > > > > > > -- > > > > > > > > > > > > - Lars > > > > > > > > > > > > > > > > > > > > > > > >
THanks!
-- - Lars [quoted text, click to view] "Jacco Schalkwijk" <NOSPAMjaccos@eurostop.co.uk> wrote in message news:ubTWrB4pDHA.1324@TK2MSFTNGP09.phx.gbl... > In the Books Online index: > objects-SQL-DMO, Database > methods-SQL-DMO, Transfer > objects-SQL-DMO, Transfer > objects-SQL-DMO, Transfer2 > > I couldn't find any examples in C++, but here is one in VB: > http://sqldev.net/download/sqldmo/80/vb6/TransferEvent.cls.txt > > -- > Jacco Schalkwijk > SQL Server MVP > > > "Lars Grøtteland" <lars@nospam> wrote in message > news:uRAwq23pDHA.688@TK2MSFTNGP10.phx.gbl... > > What's the syntax - or where can I find it in SQL-DMO bol > > > > > > -- > > > > > > - Lars > > > > > > "Jacco Schalkwijk" <NOSPAMjaccos@eurostop.co.uk> wrote in message > > news:uvJ$E22pDHA.1656@tk2msftngp13.phx.gbl... > > > If you want to do it from inside you application, use SQL-DMO. You can > > copy > > > the complete database without using a script with the Database.Transfer > > > method, or you can generate a script with the Database.Script method. > Both > > > method have a rather long list of parameters, which is a bit too much to > > > mention here, but whihc you can find in Books Online. The parameters > > > basically allow you all the options you have when copying a database or > > > generating a script from Enterprise Manager. > > > > > > -- > > > Jacco Schalkwijk > > > SQL Server MVP > > > > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > > news:%23fvQzD2pDHA.648@TK2MSFTNGP11.phx.gbl... > > > > Yes I know I can do this in QA, but how to do it in my application? > > > > > > > > Was thinking of making a SP, inside the model database. I think I've > > read > > > of > > > > this database once - that if I create one SP inside this, this should > > be > > > > copied to the new database that's been created. Is this a solution? > > > > > > > > -- > > > > > > > > > > > > - Lars > > > > > > > > > > > > "oj" <nospam_ojngo@home.com> wrote in message > > > > news:uysZi11pDHA.1728@TK2MSFTNGP09.phx.gbl... > > > > > Yes. Create a script and deploy it. > > > > > > > > > > -- > > > > > -oj > > > > > RAC v2.2 & QALite! > > > > > http://www.rac4sql.net > > > > > > > > > > > > > > > > > > > > "Lars Grøtteland" <lars@nospam> wrote in message > > > > > news:%23BMkny1pDHA.2064@TK2MSFTNGP11.phx.gbl... > > > > > > Hello! > > > > > > > > > > > > Was wondering how I can create a copy of one database? FYI I'm not > > > > > > interrested in the data, just the fields and triggers, and so on. > > > > > > > > > > > > Which way is the easiest? Do I create a script and run it from > > there? > > > Is > > > > > it > > > > > > smart to have it inside a SP? > > > > > > > > > > > > Any idea would be greatly appreciated. > > > > > > > > > > > > I'm programming SQL 2k and VC7.0 > > > > > > > > > > > > -- > > > > > > > > > > > > > > > > > > - Lars > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
August 2006
September 2006
October 2006
December 2006
January 2007
March 2007
April 2007
May 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |