且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在SQL Server中创建用户特定的数据库

更新时间:2022-11-24 17:16:37

我建​​议您,当新的商店经理注册时,从您的网络应用程序运行DB脚本。



1。连接到主数据库并运行创建数据库查询。

2.连接到刚刚创建的数据库并执行所有其他脚本(创建数据库,创建表,创建视图,创建过程,创建函数等)

3.在您的网络应用程序中使用数据库,如您所愿.......



如果有帮助,请标记为答案.. ..
I would suggest you, when a new store manager signs up, run the DB Scripts from your web application.

1. connect to master db and run create database query.
2. connect to database just created and execute all other scripts(create db, create tables, create view, create procedure, create function, etc.)
3. use the database in your web application, as you like.......

Mark as answer if helpful....


(我无法查看该图片。)





创建一个每个用户的这个数据库的副本



那个d听起来不是一个好主意。你究竟想要完成什么?
(I can't view that image.)


"create a copy of this database for each user"

That doesn't sound like a very good idea. What are you actually trying to accomplish?