This option is required if /targetLocation was omitted.Ĭonnection string of the database you're migrating to.įor example, password-protected SQLite file: Data Source=c:\mydb. Points to a location of the database you're migrating to. This option is required if /targetConnectionString was omitted. This option is required if /sourceLocation was omitted.Ĭonnection string of the database you're migrating from.įor example, password-protected SQLite file: Data Source=c:\mydb.db Version=3 Password=myPassword įor example, SQL Server with standard authentication: Server=localhost Database=SQLEXPRESS User Id=sa Password=password Points to a location of the database you're migrating from.įor SQLite it is a path of the database file, for example: C:\ProgramData\Red Gate\SmartAssembly 7\SmartAssemblySQLite.dbįor SQL Server it's a host and instance name, for example. This option is required if /sourceConnectionString was omitted. Run the following in the command line: MigrateDataCore.exe /source=SQLServer /sourceLocation=".\SQLEXPRESS" /target=SQLite /targetLocation="C:\ProgramData\Red Gate\SmartAssembly 7\SmartAssemblySQLite.db" You should see the migration taking place, and finally a Transfer completed message will appear: Run the following in the command line: MigrateDataCore.exe /source=SQLite /sourceLocation="C:\ProgramData\Red Gate\SmartAssembly 7\SmartAssemblySQLite.db" /target=SQLServer /targetLocation=".\SQLEXPRESS" You can then deploy the schema into the blank database and then use that database to create your image.
![red gate sql toolbelt copy database red gate sql toolbelt copy database](https://developer.team/vault/images/2017/09/22/Mc83.png)
![red gate sql toolbelt copy database red gate sql toolbelt copy database](https://origin2.cdn.componentsource.com/sites/default/files/styles/image_large/public/images/product_screenshot/red-gate/red-gate-sql-toolbelt/img_456291.png)