Post reply

I need some creative ideas for getting data into Azure

  • August 28, 2018 at 10:43 am

    #408319

    About 4 years ago I took a small SQL Server database I have at home and copied it to Azure SQL Database. I've got to do the same thing again, but here at work. I had been following this blog post, which is more current than when I did it. However, due to things beyond my control, I cannot get access to the .BACPAC file that I created, nor can I get anyone else to help me with it. So, now I'm wondering about some alternative ways of getting the data there.

    First, you need to know that this is a developer database on a server. There is no PHI nor PII data here. It's all make-believe stuff. We used some software to generate the fake data. Anyway, I'm thinking that I could generate the SQL scripts that would re-create the tables in Azure SQL Database. (Not sure how, but I'm guessing I could do that.) However, once I get that done, how do I go about generating some extract of the data in some flat file, so that I can get it into Azure SQL Database? I'm hoping this is possible.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • August 31, 2018 at 3:17 am

    #2004106

    Hi Rod,

    Have you tried this method? 

    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sql-server-database

    Rgds,

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

  • August 31, 2018 at 8:18 am

    #2004136

    No, I have not tried that. I wasn't even aware of that. Before I begin what does, "Create a server-level firewall in the Azure portal (if not previously created)" mean? How do I go about doing that?

    Kindest Regards, Rod Connect with me on LinkedIn.

  • August 31, 2018 at 10:14 am

    #2004152

    I think I've got the answer to my follow-up question.

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply