|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Help replicating a sql server databaseI need to replicate a SQL Server 2000 database that exists in a hosted
environment with only primative web-based management tools. I have one tool that creates a .bak file, and another tool for running queries. There seems to be no way to automatically script the tables the way we can in Enterprise Manager or SQL Server Management Studio. I have never worked with .bak files. Does the .bak file contain both schema and data, so that it can be restored into an empty SQL Server instance, or does is contain only data? If the .bak file contains only data, then please tell me which sql statements I would use to write a query that will output scripts for creating the tables. I would also appreciate any web links that may help. Many thanks, Keith |
|||||||||||||||||||||||