September 18, 2014 at 1:25 pm
Hi,
I am trying to deploy an SSDT project to SQL Server Express on a Windows Azure machine. I've tried quite a few things and can't get anything to work. We've been copying backups but the test data gets destroyed every time doing this so I need a better strategy.
Strategy 1: Connect to SQL Server on the Azure machine and deploy from within SSDT.
Problem: I can't get the connection to work, even through SSMS from my local machine. I created a SQL Server login on the remote box since we're not on the same domain, opened the port for incoming requests via the firewall. I'm a developer and not much into networking but I read quite a bit before doing this. All I did was open the SQL Server port for incoming requests. It is static, not dynamic. From Windows Azure, I'm able to connect using the ip,port which bounces out of the domain from my understanding but I can't do it from my local box. I only see an ipv6 address using ipconfig so don't know if that could be related to the problem. (There's a local 10. ip address ipv4 but that won't work).
Strategy 2: Create a dacpac file and deploy it. I do not want a bacpac because I'm trying to preserve existing data.
Problem: I copy the dacpac file to the Azure machine. In ssms, I right click databases and select "Deploy Data-tier Application". Go through the wizard and at the end I get "Unable to connect to target server". The same process works on my local machine. I'm pretty sure I don't have any hard-coded server references in my project. The only way there could be is if SSDT put them in there because I've used the macros everywhere: [($Database)].
Any advice is greatly appreciated. I've grown dependent on SSDT so no longer keep up with change scripts for deployment. I'm hoping I don't have to go down that route since I'm a few months into the project and haven't done any of that yet.
September 20, 2014 at 6:15 am
Maybe this article Migrating a Database to SQL Azure using SSDT will help
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply