February 1, 2019 at 8:32 am
I'm on a team to start a new project, migrating an Excel spreadsheet to a SQL Server database, so we can write SSRS reports against it. One thing I'd really like to do is use SSDT to develop the database, something I've never done before, but I want to do this because as far as I know, none of our SQL code, database schemas, etc. are in source control. Since SSDT is in Visual Studio, I know I can put it there.
However, after we meet with the users of this spreadsheet, we'll probably import the whole thing, as is, into a new database. I know that the spreadsheet is several columns wide and naturally being a spreadsheet it's just one wide, flat table. From that I want to develop the database schema, and that's where SSDT comes in. But if we do it all within the same database, would that cause a problem when creating the new tables using SSDT?
Kindest Regards, Rod Connect with me on LinkedIn.
February 1, 2019 at 9:44 am
There are no technical reasons why this would cause problems.
But if your spreadsheet users change the schema of the spreadsheet, as users tend to do, those changes will have to be reflected in your db project.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply