sql server - move tables from master to new database
In an attempt to move my DB to a new server I had to run the script from cmd prompt and forgot to assign the DB name and all my tables were created under master. Is it possible to move these tables to a diffe开发者_高级运维rent DB or do I need to rerun the script?
You would need to rerun the script.
There is no way to move tables between databases.
Why don't you just create the new database, create the tables, insert rows from tables in Master to your database, then drop the Master tables?
精彩评论