twoLeftFeet
Reputation: 720
SSIS Use with SQL Server Express
We have a full SQL Server license, and are planning on setting up a SQL Server Express to house a different set of data.
Is it possible to install SSIS using the full SQL Server License and then to migrate data into a SQL Server Express?
Additional Details:
- Our SQL Server Express will house data for ArcGIS Server Workgroup (which is limited to using SQL Server Express)
- The data will be coming out of a PostgreSQL database and being migrated to the SQL Server Express
- The data is completely tabular, no geometry will be migrated via this method
Cheers.
Upvotes: 0
Views: 108
Answers (1)
Gareth
Reputation: 5243
Yes.
You'll be connecting to the SQL Server Express instance as a data source and therefore will be able to interact with it in the same way as a non-express instance of SQL Server.
As it is a data source, SSIS does not care whether it's getting the data from a paid for / free version of SQL Server / any other RDBMS.
Upvotes: 1
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- Inserting multiple rows in a single SQL query?
- How to add a column with a default value to an existing table in SQL Server?
- Check if table exists in SQL Server
- How do I UPDATE from a SELECT in SQL Server?
- How do I escape a single quote in SQL Server?
- How to check if a column exists in a SQL Server table
- How can I do an UPDATE statement with JOIN in SQL Server?
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- How can I delete using INNER JOIN with SQL Server?