[SQL Server Data Warehousing] Script to drop and restore database in SQL

Hello Sathya

Thanks for your response. I have production databases and development databases. Sometimes for testing purpose, I need to use development databases and i want development database to have exact number of tables, data and logins.

So i restore prod database to dev database. which I do mannually. Now i want some scripts which i can put SQL job, so whenever I need to sync whole database, i can just run that job or automate job periodically.

Thanks

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Script to drop and restore database in SQL

Hello Sathya

Thanks for your response. I have production databases and development databases. Sometimes for testing purpose, I need to use development databases and i want development database to have exact number of tables, data and logins.

So i restore prod database to dev database. which I do mannually. Now i want some scripts which i can put SQL job, so whenever I need to sync whole database, i can just run that job or automate job periodically.

Thanks

.

social.technet.microsoft.com/Forums

[SQL Server Data Warehousing] Script to drop and restore database in SQL

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.

Would you like to participate?

.

social.technet.microsoft.com/Forums