Why isn't the data in a table not transferring?
adrianmaull
Posts: 2
I have a SQL Packager issue. It doesn’t package and copy data. I even set up a very simple database update scenario to make sure I wasn’t doing something incorrectly. Below are the steps.
I create a simple database with one table. Let’s call this DB1.
I basically copy that database and add another table. Let’s call this table DB2.
I assign a primary key and add data to this table.
I use SQL Packager to build the update exe by comparing DB2 to DB1.
I run the .exe to update DB1.
The results:
The new table is created in DB1 but the data is not copied over. Why? What am I doing wrong?
I create a simple database with one table. Let’s call this DB1.
I basically copy that database and add another table. Let’s call this table DB2.
I assign a primary key and add data to this table.
I use SQL Packager to build the update exe by comparing DB2 to DB1.
I run the .exe to update DB1.
The results:
The new table is created in DB1 but the data is not copied over. Why? What am I doing wrong?
Comments
Thanks for posting. There is a known issue with database 'upgrade' packages when a new table is introduced. The problem is that Packager wants to compare two tables' data to produce the upgrade script and it can't do the comparison because the table doesn't exist in both databases.
Packager would require you to create two executables: the first to add the new table schema and the second to compare and synchronize the data in this new table.
Note this doesn't affect 'create database' packages.