开发者

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?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜