Joerg Mehlhorn
-
2,067 votesplanned ·
AdminGuy Haycock
(Senior Product Planner, Microsoft Windows Azure)
responded
thanks, we hear you loud and clear. Free text search is planned for SQL Azure. Right now I can’t give you a date.
Joerg Mehlhorn
gave this 3 votes
·
-
1,595 votesplanned ·
AdminMary Beth Thome
(Admin, Microsoft Windows Azure)
responded
For information about what’s coming from SQL Azure, go to about 38:00 in this presentation from TechEd. http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI313
Joerg Mehlhorn
gave this 2 votes
·
For all the guys needing backups:
you can think about exporting the database with the daccli import / export tool. http://sqldacexamples.codeplex.com/releases/view/77085
To be on the safe side for transactions.
1st copy your prod-db to a prod_copy-db
this allows you to already use it as a standby database
2nd you can export the prod_copy-db to a local file
3rd the prod_copy-db can be deleted
4th be sure that the bacpac-export file can be reimported: if there is an inconsitancy in say views or procedures the import-tool currently stops importing.
5th all the above tasks can be automated and scheduled.
That's it ...