Copy database
Tech-Archive recommends: Fix windows errors by optimizing your registry
What is the best way to copy an entire SQL Server 2K DB? I want to take an
existing DB on one computer, and move its entirety to another. It seems
that DTS will only import/export tables... I'd like to be able to get the
whole enchilata, schema, tables, etc.
.
Relevant Pages
- Re: How can gather a tables schema from SQL Server 2005?
... Blog: http://cs.rthand.com/blogs/blog_with_righthand/ ... > How can gather a table's schema from SQL Server 2005? ... Prev by Date: ...
(microsoft.public.dotnet.framework.adonet) - .Net 2.0: creating XSD files from SQL Table
... I used to drop tables from a Sql server on a component or a ... This schema is used somewhere in the code to create dataset according ... the dataset XSD file is quite different and I don't want to ... Prev by Date: ...
(microsoft.public.dotnet.framework) - .Net 2.0: creating XSD files from SQL Table
... I used to drop tables from a Sql server on a component or a ... This schema is used somewhere in the code to create dataset according ... the dataset XSD file is quite different and I don't want to ... Prev by Date: ...
(microsoft.public.dotnet.framework) - Re: multiple cascade paths
... You should not have them if your schema is designed properly. ... make you understand that I tried to show that a proper design can have ... am a SQL Server MVP, for crying out loud - you can safely assume that I ...
(comp.databases.ms-sqlserver) - Re: Need help on how to organize users and objects
... Yes Oracle is a bit different than Sql Server, but I think you will get the ... It doesnt become part of any schema until you assign it. ... a new developer started to work. ... need the COMMON database which stores tables with generic data and generic ...
(microsoft.public.sqlserver.security) |
|
