HOWTO创建一个数据库的副本 [英] HOWTO create a copy of one database

问题描述

您好！


想知道如何创建一个数据库的副本？我不是因为数据，只是字段和触发器等等而对b $ b感兴趣。


哪种方式最简单？我是否创建了一个脚本并从那里运行它？将它放入SP中是否很聪明？


任何想法都会非常感激。


我''编程SQL 2k和VC7.0

-

- Lars

解决方案

是的。创建一个脚本并进行部署。


-

-oj

RAC v2.2& QALite！
http://www.rac4sql.net


" Lars Gr？tteland" <拉斯@ NOSPAM>在消息中写道

新闻：％2 **************** @ TK2MSFTNGP11.phx.gbl ...

你好！

想知道如何创建一个数据库的副本？我不是对数据感兴趣，只是对字段和触发器等感兴趣。

哪种方式最简单？我是否创建了一个脚本并从那里运行它？将它放入SP中是不是很聪明？

任何想法都会非常感激。

我正在编写SQL 2k和VC7.0

-

- Lars

Lars

右键单击数据库，然后单击All tasks，然后生成SQL脚本。

将其保存为.sql（或其他）文件，如果

，您可以从QA或更高版本运行它需要从档案中获取。


Lars Gr？tteland <拉斯@ NOSPAM>在消息中写道

新闻：#B ************** @ TK2MSFTNGP11.phx.gbl ...

你好！

想知道如何创建一个数据库的副本？我不是对数据感兴趣，只是对字段和触发器等感兴趣。

哪种方式最简单？我是否创建了一个脚本并从那里运行它？将它放入SP中是不是很聪明？

任何想法都会非常感激。

我正在编写SQL 2k和VC7.0

-

- Lars

是的我知道我可以在质量保证中这样做，但是如何在我的应用程序中执行此操作？


正在考虑在模型数据库中创建SP。我想我已经读过这个数据库了一次 - 如果我在这里创建一个SP，这应该是

被复制到新的数据库中了创建。这是一个解决方案吗？


-

- Lars

" oj" <无********** @ home.com>在消息中写道

新闻：uy ************** @ TK2MSFTNGP09.phx.gbl ...

是的。创建一个脚本并进行部署。

-
-oj
RAC v2.2& QALite！
http://www.rac4sql.net
< br> Lars Gr？tteland" <拉斯@ NOSPAM>在消息中写道
新闻：％2 **************** @ TK2MSFTNGP11.phx.gbl ...

你好！

想知道如何创建一个数据库的副本？我不是对数据感兴趣，只是对字段和触发器等感兴趣。

哪种方式最简单？我是否创建了一个脚本并从那里运行它？

它

聪明地把它放在SP里面吗？

任何想法都会非常感激。

我''编程SQL 2k和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. Create a script and deploy it.

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net

"Lars Gr?tteland" <lars@nospam> wrote in message
news:%2****************@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.

"Lars Gr?tteland" <lars@nospam> wrote in message
news:#B**************@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 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" <no**********@home.com> wrote in message
news:uy**************@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:%2****************@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

这篇关于HOWTO创建一个数据库的副本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！