I need to migrate data to a SQL Server 2014 database from an existing Compact SQL Server 4.0 database. I'm having difficulty because my computer runs SQL Server 2012 so I'm not able to port the data via a graphical wizard.

I am able to run scripts on all databases. I just don't know how to perform a the data migration without a graphical interface.

I need to migrate data to a SQL Server 2014 database from an existing SQL Server CE 4.0 database. I'm having difficulty because my computer runs SQL Server 2012 so I'm not able to port the data via a graphical wizard.

I am able to run scripts on all databases. I just don't know how to perform a the data migration without a graphical interface.

I need to upload data to a SQL 2014 Database, my computer runs SQL 2012 so I'm not able to manipulate the tables in a graphic way. I'm only able to run SQl queries. I want to upload to the database data created in a Compact SQL 4.0 Database in Visual Studio.

How can I get the SQL query of the compact database to run it in the 2014 DB?

I need to migrate data to a SQL Server 2014 database from an existing Compact SQL Server 4.0 database. I'm having difficulty because my computer runs SQL Server 2012 so I'm not able to port the data via a graphical wizard.

I am able to run scripts on all databases. I just don't know how to perform a the data migration without a graphical interface.