I am following this tutorial from AWS to export a SQL Server database that currently sits on my laptop to Amazon Web Services RDS. In particular I am trying the Generate and Publish script wizard followed by bulk copy.
The script that gets generated starts like this:
CREATE DATABASE [Test] CONTAINMENT = NONE ON PRIMARY ( NAME = N'Datapump_Test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Datapump_Test.mdf' , SIZE = 1127424KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'Datapump_Test_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Datapump_Test_log.ldf' , SIZE = 2160960KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO
So my question is what are those paths for (i.e. the
C:\..... lines) and are they pointing to files on my laptop? And if so, should I change them when I run this script on the RDS DB? I find that if I leave them there it will error, but if I manually create the DB in SSMS and then comment out these lines and run the script, I still get many errors, but it does create all the table schemas, user and indices etc... so is this the correct approach? If it is, it seems strange that the link I posted above doesn't mention this. This makes me think I've done something wrong. Does anyone have any insight on the matter?