部分导入Sql server 2005数据库进行本地开发
因此，在工作中，我的团队使用中央 SQL Server 2005 数据库服务器进行集成测试，我想转向在本地数据库上进行测试。 唯一的问题是中央数据库超过 10 GB。
我有兴趣导入数据对象和每个表的行，以确保我可以启动并运行。 你们能告诉我如何做到这一点吗？
我有VS 2008 Professional和SQL Server Management Studio Express。 我需要 VS 2008 数据库版本吗？
谢谢 -Venu
编辑：我将尝试登录中央数据库服务器并查看主机是否有更好的工具。 谢谢 kpollock，我没想到这一点。
So at work, my team is using a central SQL server 2005 database server for integration testing and I want to move to testing on my local database. The only problem is that the central database is in excess of 10 Gb.
I am interested in importing the data objects and a rows for each table to ensure I can be up and running. Can you guys advise me on how I can do this?
I have VS 2008 professional and SQL Server management studio express. Would I need VS 2008 database edition?
Thanks
-Venu
EDIT : I will try logging into the central database server and seeing if the host machine has better tools. Thanks kpollock, I didn't think of that.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
2005 和 2008 Express 版本有 4 GB 限制。
您是否考虑过在中央服务器上制作数据库副本并处理它（只需将其恢复到具有其他名称的新数据库中）？
另请参阅 SQL Server 中的备份和恢复 --完整备份
Both 2005 and 2008 Express editions have 4 gb limitation.
Have you thought about making a db copy on central server and dealing with it (just restore it into new db with other name)?
See also BACKUP and RESTORE in SQL Server -- Full Backups
对我来说，这看起来像是 SSIS 工作 - 我认为 Management Studio Express 版本没有。
或者，您可以在 C# 中调用源数据库上的存储过程来提取数据（如果您的技能就在于此）。 （这就是我会这样做的，因为我认为它更容易理解 - 但这只是我的意见）。
如果数据库是活动的并且新数据一直进来，也许您可以设置架构和引用数据，然后使用复制来获取新数据（如果您认为这会给您带来代表性样本）。
您必须根据对模式的理解对样本提取进行编码 - 即确保您获得完整的链接记录集（例如订单的详细记录和所有查找，例如客户、地址等）。
Looks like an SSIS job to me - which I think Express version of Management Studio doesn't have.
Or you could do it in C# calling Stored procs on the source database to extract the data if that's where your skills lie. (this is how I would do it as I think it's more widely comprehensible - but that's just my opinion).
If the database is live and new data comes in all the time perhaps you could set up the schema and reference data only then use replication to get the new data as it comes in (if you think that will get you a representative sample).
You will have to code up the sample extraction based upon an understanding of the schema - i.e. ensure you get a full set of linked records (e.g detail records for orders and all lookups e.g. customer, addresses, etc.).