How to create SQL script of the existing table or database
in [Server Configuration]
|
Prev: Couldnt Take Script using SMO columns binded default values
Next: SQL 2008 Policy management through sql queries
From: Zaur Bahramov on 4 Jul 2008 05:39 Hi! Is there a way to create a script from the existing database, Adventure Works for example? I mean, some way to export not only a table structure, for example, but also data into a sql script, so that if I run it, it will create me both table and insert all data. Is it possible to script the entire database also? Zaur
From: vinu on 4 Jul 2008 06:27 Zaur, See Integration Service/BCP in BOL vinu "Zaur Bahramov" <zbakhramov(a)msn.com> wrote in message news:u6BdUnb3IHA.3348(a)TK2MSFTNGP03.phx.gbl... > Hi! > > Is there a way to create a script from the existing database, Adventure > Works for example? I mean, some way to export not only a table structure, > for example, but also data into a sql script, so that if I run it, it will > create me both table and insert all data. Is it possible to script the > entire database also? > > > Zaur > >
From: Tibor Karaszi on 4 Jul 2008 08:29 Some elaborations on tools and options: http://www.karaszi.com/SQLServer/info_generate_script.asp -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Zaur Bahramov" <zbakhramov(a)msn.com> wrote in message news:u6BdUnb3IHA.3348(a)TK2MSFTNGP03.phx.gbl... > Hi! > > Is there a way to create a script from the existing database, Adventure > Works for example? I mean, some way to export not only a table structure, > for example, but also data into a sql script, so that if I run it, it will > create me both table and insert all data. Is it possible to script the > entire database also? > > > Zaur > >
From: Uri Dimant on 6 Jul 2008 01:28
Zaur Take a look www.red-gate.com "Zaur Bahramov" <zbakhramov(a)msn.com> wrote in message news:u6BdUnb3IHA.3348(a)TK2MSFTNGP03.phx.gbl... > Hi! > > Is there a way to create a script from the existing database, Adventure > Works for example? I mean, some way to export not only a table structure, > for example, but also data into a sql script, so that if I run it, it will > create me both table and insert all data. Is it possible to script the > entire database also? > > > Zaur > > |