I often need to copy a table or a view from one database to another on the same sql server.
I am using SQL Server Management Studio 2005.
There is no drag-and-drop way of transfering tables or views.
(only these boring wizards)
How could I work easier?
Are there some (free) tools allowing for some drag and drop?
Are there some more visual tool than these MS wizards I am wasting my time with?
Would you know why ssms works with this "Script ... as" stuff ?
Basically I upgraded several of my Access databases to sqlserver, and I find this ssms rather strange and old-fashion (reminds me teletype commands!). I must be wrong of course, but why?