Run SQL Server Management Studio, right click on the database and select Script Database as Create to file That's for SQL Server 2005. SQL 2005's Management studio may handle the objects as well, but the database is in an environment where there is no way for me to connect an installation of Management Studio to it. I end up with a script that contains a CREATE DATABASE command, and creates none of the objects - the tables, the constraints, etc. When I select the option to generate a create script on a database.
#L2phx 3.1.8 interlude update#
I'm looking for something better than this manual solution Additional Update Unless I'm completely missing something, this is not a viable solution using the SQL 2000 tools.
Update: The database I'm working with has 200+ tables and several foreign-key relationships and constraints, so manually scripting each table and pasting together the script is not a viable option. The top reviewer of Toad writes 'Whatever database issues I have, I use this product to solve them'.Īny simple.exe (no installation required) tools, tips, or T-SQL tricks would be much appreciated. Redgate SQL Toolbelt is ranked 14th in Database Development and Management vs Toad which is ranked 6th in Database Development and Management with 4 reviews. For many companies, particularly those in the financial sector, a key technology. Introducing database automation with the SQL Toolbelt. I can't afford RedGate, but I really would like to have a database with identical schema on another server.
#L2phx 3.1.8 interlude install#
I am working in an environment that has SQL Server 2000 installed, and I am unable to install the 2005 client tools (in the event that they would help). In essence, I want to end up with a big create script that captures the database schema. I'm in a situation where I would to generate a script for a database that I could run on another server and get a database identical to the original one, but without any of the data.
0 kommentar(er)
