Hi
I have to work offsite from the client offices and their main database requires restructuring e.g. they currently have over 10 indexes on most tables and up to 38 on some (ouch)
Could someone recommend the tools to enable me to download the database structure (no data transfer) and the relationship between the tables to help me restructure the database?
Thanks in advance
Hi,
You have several options to accomplish this task. You can use SSIS to copy database objects, create a database script through the EM or SSMS, or use the Database Publishing wizard from http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard&referringTitle=Home
Regards,
Janos
No comments:
Post a Comment